Home » Forums » Open Source Learning Center » Question and Answer

=IF

Submitted by Tim on 5 December, 2014 - 02:46

=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

‹ need VBA to Transpose the Data from excel to word based on given criteria(status) how to make total from data list validation ›
»

Answer =IF

Submitted by Tanujkumar88 on 18 December, 2014 - 18:30.

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

»