Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|