I have a formula along the lines of..... =IF((a1=b1),1,0) How can i get the formula to ignore blank cells? Configuration: Windows XP / Internet Explorer 6.0

Ignoring blank cells

Closed

adamsalter Posts 1 Registration date Wednesday May 12, 2010 Status Member Last seen May 12, 2010 - May 12, 2010 at 08:17 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 12, 2010 at 09:09 AM

I have a formula along the lines of..... =IF((a1=b1),1,0)

How can i get the formula to ignore blank cells?

Ignoring blank cells
Discord blank name ✓ - Internet & Social Networks Forum
Based on the values in cells b77 ✓ - Excel Forum
Different dates of "end to end encryption message" on blank chat? - Excel Forum
Facebook page blank ✓ - Facebook Forum
Based on the values in cells b77 b88 ✓ - Excel Forum

1 response

Answer 1 / 1

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
May 12, 2010 at 09:09 AM

=IF(AND(a1=b1, A1<>""),1,0)

Similar discussions

encryption message several time in chat

help me to add particular cells

IF statements with dates and criteria

blank white page for website

using web browser page loads but screen blank

Similar discussions

Subscribe To Our Newsletter!