Here is the formula:

=IF(AE560,IF(AG560,IF(AE560,IF(AG560,(AE56+AG5 6)-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

There seem to be many unnecessary components in your formula.
Why not just =IF(AE560,IF(AG560,AE56,""),"") or
=IF(AND(AE560,AG560),AE56,"") ?
--
David Biddulph

"al619" wrote in message
...
Here is the formula:

=IF(AE560,IF(AG560,IF(AE560,IF(AG560,(AE56+AG5 6)-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

Direct answer:
=IF(ISERROR(IF(AE560,IF(AG560,IF(AE560,IF(AG56 0,(AE56+AG56)-AG56,""),""),""),"")),"",IF(AE560,IF(AG560,IF(AE 560,IF(AG560,(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(AE560,AG560),AE56,""),"",IF(A ND(AE560,AG560),AE56,""))


--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"al619" wrote:

Here is the formula:

=IF(AE560,IF(AG560,IF(AE560,IF(AG560,(AE56+AG5 6)-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

Thank you for your help, It worked.
al619

"al619" wrote:

Here is the formula:

=IF(AE560,IF(AG560,IF(AE560,IF(AG560,(AE56+AG5 6)-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