Hi Everyone,

This should be a simple IF formula, but I keep running into errors. I want to see if two columns have the same Total Amount, but to say Yes, or ignore, if the second column is blank.

For example:

A2 = $50,000
B2 = $50,000

Match

A2 = $50,000
B2 =

Match

A2 = $50,000
B2 = $55,000

Not a Match

The reason we are doing is this is because we have a database that we feel will be a match 90% of the time between these columns. Our team always updates column A but not always column B so we want to see where there are genuine disparities and not just the team skipping a step.

I could always just filter out anything in Column B that is Blank after running the formula, but I am curious if there is a way to actually get it in the function.

Thanks,
Kevin