• 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

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:
Top