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