I have the following formula:
I want it to show zero if cell 'D6' is also zero. I tried nesting more IF statements but keep getting errors. Any ideas?
Code:
=IF(D5="Fixed Price",0.5,IF(AND((D6*D9)>=0.01,(D6*D9)<=0.99),0,IF(AND((D6*D9)>=1,(D6*D9)<=9.99),0.25,IF(AND((D6*D9)>=10,(D6*D9)<=24.99),0.5,IF(AND((D6*D9)>=25,(D6*D9)<=49.99),0.75,IF(AND((D6*D9)>=50,(D6*D9)<=199.99),1,IF(AND((D6*D9)>=200,(D6*D9)<=499.99),2,IF((D6*D9)>=500,2,0))))))))*IF(G16="Yes",2,1)