ExcelBanter - Get rid of #value!

Thanks alot.

"Max" wrote:

Try: =IF(OR(I10="",K10=""),"",SUM(I10-(I10*K10)))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Curtis" wrote:
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?