take out #VALUE!

[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

 

[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,""))

 

[al619]

Thank you for your help, It worked.
al619