=IF

=IF(C3<=2,150,IF(C3<=5,B3*0.11%,IF(C3<=10,B3*0.1375%,IF(C3<=50,B3*0.165%))))

how do i add a rule that if B3=0 the (IF calculation) wont take place-(the above formula is in D3) so if B3=0 D3 =0

Answer =IF

Hi,

I hope this function will work for you.

=IF(B3=0,0,IF(C3<=2,150,IF(C3<=5,B3*0.11%,IF(C3<=10,B3*0.1375%,IF(C3<=50,B3*0.165%)))))

your function is not complete , what happen if C3 more than 50 ? , your last if have no false value.

Thanks
Tanuj