If > 10 and if < 10 formula

[Kelli Webb]

Hello,

I'm trying to nest (if that's the right terminology) Value should be if >10, 10*(rate*1.5)+hours <10 *(rate*2) and if <10,hours *(rate*1.5)

Any help would be greatly appreciated.

kind regards,

 

[Nebu]

Hi:

May be this?

=IF(B2>10,(10*(A2*1.5))+(B2*(A2*2)),B2*(A2*1.5))

Thanks

 

[Kelli Webb]

F(B2>10,(10*(A2*1.5))+(B2*(A2*2)),B2*(A2*1.5))

Hi Nebu, The <10 appears to be working correctly, but not the > 10, or is it me?
Kelli

 

[Kelli Webb]

Hi Nebu, The <10 appears to be working correctly, but not the > 10, or is it me?
Kelli

hang on, I think I've got it

=IF(B4>10,(10*(A4*1.5))+((B4-10)*(A4*2)),B4*(A4*1.5))

Thanks Nebu for sending me in the right direction!!

Kelli

 

[p45cal]

A little shorter:
=(MIN(10,B2)*1.5+MAX(0,B2-10)*2)*A2

and shorter:
=IF(B2<10,1.5*B2,2*B2-5)*A2