Hi All,
Example: If any one of these cells A20:A28 show the word "RALPH" then cell C16 to read "Y" otherwise leave cell C16 blank.
So if any single one of the cells from A20:A28 contain the word "RALPH", cell C16 to read "Y" or leave blank.
Seems a simple task but I am struggling.
I have tried; =IF(A20:A28="RALPH","Y","") entering this formula in C16. Result shows #VALUE!
That is after entering the name RALPH in one cell of the range A20 to A28.
Any assistance would be very helpful.
Thanks
Bookmarks