IF Function which looks at more than one cell

**McCaughley7** · 10-31-2016, 01:15 PM

Hi All

I am trying to write a formula in Cell B2 that looks at 3 Cells (A1,A2,A3) and if any of the 3 cells are populate with text or number returns "Yes" and if all 3 are blank it returns "No".

Thanks for looking

**Glenn Kennedy** · 10-31-2016, 01:24 PM

Try:

=IF(AND(A1="",A2="",A3=""),"No","Yes")

**McCaughley7** · 10-31-2016, 01:42 PM

Perfect - thank you so much Glenn

**Glenn Kennedy** · 10-31-2016, 01:45 PM

You're welcome!! Nice to see someone else from Ireland on here.... There aren't too many of us here!!

**Tony Valko** · 10-31-2016, 01:57 PM

Here's another one...

=IF(COUNTA(A1:A3),"Yes","No")

IF Function which looks at more than one cell

LinkBack

Thread Tools

Rate This Thread

Display

IF Function which looks at more than one cell

Re: IF Function which looks at more than one cell

Re: IF Function which looks at more than one cell

Re: IF Function which looks at more than one cell

Re: IF Function which looks at more than one cell

Thread Information

Users Browsing this Thread

Similar Threads

Small1, Small2, Small3 marks are same Index function and Cell address function not working

index function error using match function to get data from a cell in an array

if cell is wrapped with IFERROR function, then delete the function from the cell

Combine time cell and function cell with new function

Split 1 cell into 2 using delimiter by function not text to columns function

Inserting an INDEX,MATCH function into a HYPERLINK function instead of cell reference

[SOLVED] A correct IF function doesn't show the function's result in cell

Bookmarks

Bookmarks

Posting Permissions