# If > 10 and if < 10 formula

#### Kelli Webb

##### Member
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,

#### Attachments

• 8.8 KB Views: 6

#### Nebu

##### Excel Ninja
Hi:

May be this?

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

Thanks

• herofox and Thomas Kuriakose

#### Kelli Webb

##### Member
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

##### Member
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

Last edited:

#### p45cal

##### Well-Known Member
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

Last edited:
• herofox