=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
ExcelExperts.comExcel Consultancy, VBA Consultancy, Training and Tips Call:+442081234832 |
|
Excel / VBA ConsultancyFree Training VideosFree SpreadsheetsExcel / VBA JobsNavigationWho's onlineThere are currently 0 users and 516 guests online.
New Excel Experts
Current Excel / VBA Jobs |
=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 |
Highest Ranked Users
Recent Blogs
ForumsRecent comments
User login |
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