Forum Discussion
OR/AND functions returning ranges
Riny_van_Eekelen thank you so much for helping.
The formula you suggested to enter in C1 didn't exactly do what I needed, as it returns a range rather than a single value, while I need the OR function to return a range, and the AND an IF functions to return a single value (guess I was not clear enough) out if it.
It does the job though, once an AND formula is added:
=IF(AND((B1:B15="")+(B1:B15=0)),"A","B").
Guess I need to look back to how arithmetic operators work on logical values in XL
Again, thanks a lot, you kinda saved my day.
Gianfranco
gpellacani Glad you figured it out, although I don't understand what you are trying to achieve.
Riny_van_Eekelen what I'm trying to achieve is to return A (a single value) if ALL cells in the B1:B15 range are either void or 0, B otherwise (i.e. if ANY cell in the B1:15 range is neither void nor 0).
The function you originally suggested returns A for EACH cell in the B1:15 range which is either void or 0, B otherwise, hence a 15-cell range
Have a great Sunday!
Gianfranco