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
An example of a cell is a blank cell ✓ - Programming Forum
Based on the cell values in cells b77 - Excel Forum
How would you change all cells containing the word pass to green - Excel Forum
Different dates of "end to end encryption message" on blank chat? ✓ - Network Forum
Excel arrow keys not moving cells - Guide

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

Fill adjacent cell with number from text answer

blank white page for website

Similar discussions

Subscribe To Our Newsletter!