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")
Help Article Resources
Check out the Formula Handbook template!