Let say I have net amount in M10 cell which is sum from cell I10 - gross
amount and K10 - discount, the way I have it formated is = sum (
I10-(I10*K10)) which I get my net amount. Now if I10 and K10 is left blank I
get #value! I try doing this
= if ( I10=0, "" , Sum( I10-(I10*K10))) if I10 is blank it works but if K10
is blank too I still get #value!. How do it get it not to show if both are
blank?