Formula to exclude blanks in an IF statement
I am trying to write a formula that compares two columns and returns a yes or no if they are equal but I don't want it to recognize a blank field as being different. How would I write that?
=IF([Estimated number of participants]@row = [Confirmed Participant Volume]@row, "No", "Yes")
Best Answer

Not sure if the blank applied to either column so this formula allows for either.
If the columns match or either column is blank it will return a 'No' otherwise 'Yes'
=IF(OR(ISBLANK([Confirmed Participant Volume]@row),ISBLANK([Estimated number of participants]@row),[Estimated number of participants]@row = [Confirmed Participant Volume]@row), "No", "Yes")
Hope that helps
Thanks
Paul
Answers

Not sure if the blank applied to either column so this formula allows for either.
If the columns match or either column is blank it will return a 'No' otherwise 'Yes'
=IF(OR(ISBLANK([Confirmed Participant Volume]@row),ISBLANK([Estimated number of participants]@row),[Estimated number of participants]@row = [Confirmed Participant Volume]@row), "No", "Yes")
Hope that helps
Thanks
Paul

This is exactly what I needed! Thank you so much
Help Article Resources
Categories
Check out the Formula Handbook template!