Need help with creating an if/then/or formula

[danielneedssomehelp]

I have three empty cells where a user can enter any of the following values. A1 = Blue, A2 = Red, A3 = Green. If someone enters nothing, I need cell B1 to remain blank, if someone enters only one value (either Blue, Red, or Green), then I need B1 to return the word "color", if someone enters more than one value (Blue and Green for example), then I need B1 to return the word "colors".

Thanks for any help!

[ConneXionLost]

How aout this:

Please Login or Register  to view this content.

Cheers,

[AlKey]

Try this

=IF(COUNTA(A1:A3)=0,"","Colors")

Or

=IF(OR(A1:A3={"Blue","Red","Green"}),"Colors","")

[danielneedssomehelp]

Ok, so to complicate things a bit...

Let's say I have cells A1:A50... if all of those cells are blank, then cell B1 is blank, if ONLY ONE of those cells is not blank, then B1 returns the word "color", if two or more cells are not blank, then B1 returns the word "colors".

Any ideas?

[ConneXionLost]

If you're going to move the goalposts, then a slight modification of Alkey's formula should work:

Please Login or Register  to view this content.

Cheers,

[danielneedssomehelp]

Thank you guys! One last thing, let's say I have formulas in cells A1:A50, and those formulas are either going to return a value of blank (""), or some text. How could I create a formula that would check cells A1:A50, and if all values were returned blank, then cell B1 is blank, if A1:A50 return only one field with text, then B1 returns the word "color", and if there are more than one cells from A1:A50 that contain text, then B1 returns the word "colors".

I'm not sure if something like this is possible because maybe Excel considers a cell with a formula in it to be text?

Thanks for any help here! I feel like I'm getting close-

[Tony Valko]

=IF(OR(A1:A3={"Blue","Red","Green"}),"Colors","")

That needs to be array entered.

[danielneedssomehelp]

So the array formula would only give a result of blank or "colors". How do I get it to return (1) blank if all cells are blank, (2) the word "color" if there is only text in one cell, and (3) "colors" if there is text in more than one cell?

And I don't want to limit the kind of text that can be in cells A1:A50 to just different colors. In other words, if there is ANY text in cells A1:A50, that counts.

[AlKey]

Dear danielneedssomehelp,

Out of what was offered before you actually never mentioned of whether or not you had any problems with the formulas. And I am wondering if you ever tried them at all. I do hope, that maybe next time, you will be better prepared regarding your requirements and for yourself have a better understanding of what your really want.

Best regards,

Alex

[danielneedssomehelp]

Yes AlKey, sorry for the confusion, and point well taken. Your formula works, my spreadsheet just started getting more complicated. Thank you for your help!