Get rid of #value!



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


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question