take out #VALUE!

A

al619

Here is the formula:

=IF(AE56>0,IF(AG56>0,IF(AE56>0,IF(AG56>0,(AE56+AG56)-AG56,""),""),""),"")

As a result, in the cells it shows: #VALUE!
How can I have the cells not show #VALUE!, instead leave the cell blank if
possible.

Thanks for all the help
al619
 
D

David Biddulph

There seem to be many unnecessary components in your formula.
Why not just =IF(AE56>0,IF(AG56>0,AE56,""),"") or
=IF(AND(AE56>0,AG56>0),AE56,"") ?
 
L

Luke M

Direct answer:
=IF(ISERROR(IF(AE56>0,IF(AG56>0,IF(AE56>0,IF(AG56>0,(AE56+AG56)-AG56,""),""),""),"")),"",IF(AE56>0,IF(AG56>0,IF(AE56>0,IF(AG56>0,(AE56+AG56)-AG56,""),""),""),""))

I notice though that your formula is very wordy, and that the math operation
is essentially AE56+AG56-AG56. Why not just say AE56? Could be condensed to:
=IF(ISERROR(IF(AND(AE56>0,AG56>0),AE56,""),"",IF(AND(AE56>0,AG56>0),AE56,""))
 
Top