• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

If > 10 and if < 10 formula

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

  • Chandoo if statement with 2 Conditions.xlsx
    8.8 KB · Views: 6
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:
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:
Back
Top