Excel Tips
Monday, April 12th, 2010 at
4:37 pm
Leave your comment
Ms Excel Formula tips (Not VBA)?
how do i insert a value in a cell from another cell
cell A1=if(sum(A5:A12)>25,F12=”Good Result”, F12=”Bad”)
the calculation will be displayed in cell A1 and cell F12 the result. I dont want cell F12 to contain any formula but just the result of the calculation in A1. is it posible?
p/s: i dont want to use VBA though its easier.
Excel functions must be enterred before it is calculated
The only way to do it without VBA is may be using scinarios, did you tried it?
I am sure can help you
I am after all the VBAXLMan here
mail me to show you how, it can not be shown here
VBAXLMan
Microsoft Excel #05: Tips, Tricks, & Form Creation
|
|
Slip Tip Syringes – 10cc $0.18 Slip Tip Syringes – 10cc… |
|
|
Slip Tip Syringes – 5cc $0.19 Slip Tip Syringes – 5cc… |
|
|
Slip Tip Syringes – 20cc $0.59 Slip Tip Syringes – 20cc… |
|
|
Excel 2003 Level 8 Tips & Tricks [VHS] $39.95 … |
|
|
EXCEL BURNISHER WITH 4 ASSORTED TIPS $5.95 EXCEL BURNISHER W/4 ASSORTED TIPS…. |
|
|
Microsoft Excel 2007 $10.49 … |
|
|
Microsoft Excel 2003 Tips, Tricks & Shortcuts presented by Dennis Taylor … |
|
|
Electric Hot Iron & Knife Tip, 30W $10.99 Electric Hot Iron & Knife Tip, 30W… |
|
|
Burnisher Handle with Tips $7.03 … |
|
|
Excel Hobby Tools Aluminum Handle Pounce Wheel With 7/16 Tip (18 teeth per Inch) 15 teeth/inch used for tracing lines. May be swiveled to follow around circles and curves or locked for straight work, for tracing quilt patterns and aluminum foil splicing…. |
