Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
=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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
=IF(AE22,"Row incomplete","") How does the "AE" fit in
There is probably another formula in AE22 that calculates whether all merged
cells are completed. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Rick H" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|