View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Rick H Rick H is offline
external usenet poster
 
Posts: 1
Default =IF(AE22,"Row incomplete","") How does the "AE" fit in

This formula is in L22, It references MERGED cells: D&E, F&G, H&I, and J&K.
If there is input in any but not all of the merged cells I get the row
incomplete message, but once all the merged cells are filled the message is
not shown. I understand the theory but where does the "AE" fit in to the
formula?
Thanks,
Rick