Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with formula please
I need a formula to say something like this
Lets say F8 is = 10 But F8 might vary I want F9 to say " If F8 is Greater than 10 multiply the difference by 1.5. SO, F8 is 12 then F9 will say 18. Is this even possible? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with formula please
Hi,
You didn't say what to do if F8 is <= to 10 so this does nothing =IF(F810,F8*1.5,"") Mike On Dec 28, 3:25*am, Juan Jimenez wrote: I need a formula to say something like this Lets say F8 is = 10 But F8 might vary I want F9 to say " If F8 is Greater than 10 multiply the difference by 1.5. SO, F8 is 12 then F9 will say 18. Is this even possible? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with formula please
What do you mean by "difference"
Difference between 10 and 12 is 2 so F9 should return 3 To return 18 in F9 if F8 is 12 per your example perhaps......... =IF(F810,F8*1.5,"else this") Gord Dibben MS Excel MVP On Sat, 27 Dec 2008 07:25:46 -0800, Juan Jimenez wrote: I need a formula to say something like this Lets say F8 is = 10 But F8 might vary I want F9 to say " If F8 is Greater than 10 multiply the difference by 1.5. SO, F8 is 12 then F9 will say 18. Is this even possible? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|