Sumif

[Muthukrishnan V]

Excel 2007.

Columns A1 and B1 contain numbers.

I want a formula to calculate:

If A1 <=500000 Output 0.
If A1 >500000 but <=1000000 output B1*10%
If A1 >1000000 output B1*15%

 

[Fluff]

How about
=IF(A1<=500000,0,IF(A1<=1000000,B1*0.1,B1*0.15))

 

[jtakw]

Hi,

Another way to write that:

=B1*IF(A1<=500000,0,IF(A1<=1000000,0.1,0.15))