Hi everyone,

Trying to come up with a formula that compares two percentages, one from today, one from yesterday, and measures whether I have traveled through a whole percentage. I'd like it then to populate a square with something like "YES" if percentage has gone through a whole integer and NO if not.

By "whole integer" I mean 1.0%, 2.0%, 3.0% as opposed to, for instance, 1.01%, 2.34%, 3.67%.

Said another way, let's say on Monday I have 4.6% and then on Tuesday I have 7.2%, the formula would test to see if I had gone through a whole percentage (in this case I have gone through 5.0%, 6.0% and 7.0%, so YES).

The data format is pretty simple.

A1 has Monday's percentage (4.6%)
B1 has Tuesday's percentage (7.2%)
C1 has the answer (YES)

I guess I am rusty as this sounds easy but is proving to be a challenge for me.

Thanks your thoughts!

J