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?

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?

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?