Simply array?

[ChristineJ]

For any row in range B1:C11, if there is an amount in both column B and column C, I want to return "Cannot have two amounts on the same row." in cell E1. (Otherwise return "OK").

Here is what is currently in E1, although not working:
{=IF(AND(B1:B11<>"",C1:C11<>""),"Cannot have two amounts on the same row.","OK")}

Can this be done?

 

[eduzs]

.........Sorry, just a moment.

 

[Fluff]

Maybe

=IF(MAX((B1:B11<>"")*(C1:C11<>"")),"Cannot have two amounts on the same row.","OK")

 

[ChristineJ]

Thanks for the suggestion - close. However, I don't want to find when both cells are equal, but when they are both not blank.

 

[ChristineJ]

Maybe

=IF(MAX((B1:B11<>"")*(C1:C11<>"")),"Cannot have two amounts on the same row.","OK")

Thanks so much! This works perfectly - just what I need. I would never have known to try this. Appreciate all the help - you have responded to me several times with solutions!

 

[Fluff]

Glad we could help & thanks for the feedback.

For future reference, when "Marking as Solution" you need to select the post that answers your question, not your post saying it works. I have changed it for you this time.

 

[ChristineJ]

Glad we could help & thanks for the feedback.

For future reference, when "Marking as Solution" you need to select the post that answers your question, not your post saying it works. I have changed it for you this time.

Yes, of course! Will be more careful on that next time. Thanks again.