View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
al619 al619 is offline
external usenet poster
 
Posts: 9
Default take out #VALUE!

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