Help with formula please

J

Juan Jimenez

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?
 
M

Mike H

Hi,

You didn't say what to do if F8 is <= to 10 so this does nothing

=IF(F8>10,F8*1.5,"")

Mike
 
G

Gord Dibben

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(F8>10,F8*1.5,"else this")


Gord Dibben MS Excel MVP
 
Top