Help with formula please

  • Thread starter Thread starter Juan Jimenez
  • Start date Start date
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?
 
Hi,

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

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

Mike
 
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
 
Back
Top