=IF(AE22,"Row incomplete","") How does the "AE" fit in

R

Rick H

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
 
B

Bob Phillips

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Lookup Across Multiple Rows / Columns 5
Strip out certain rows that have merged cells 2
Loop returns only one value, does not loop & an assignment to columnhow-to problem. 26
Count text cells if condition in row is true, over many rows. 0
Filtering data 2
Date is not permanent 2
Excel Function for select data which NOT exist from the list 18
Single column to multiple columns 5

Top