Easy IF statement but can't figure it out

[Iappreciate]

Don’t know why this is proving so difficult. I have a measure and a benchmark. If the measure is 0 (regardless of what the benchmark is) the IF statement should return a “Yes”, otherwise the IF statement should compare the measure to the benchmark and IF the measure is greater than the benchmark, it should return a “No”, if the measure is less than or equal to the benchmark, it should return a “Yes”. I’m getting stuck with the less than or equal to.

The IF statement currently reads like this: =IF(C2=0,"Yes",(IF(C2>=D2,"No","Yes")))

C is the measure and D is the benchmark. I manipulated the formula a few different ways but can’t get it to give me a “No” when the measure is equal to the benchmark. I would think that if I take out the = and make it read =IF(C2=0,"Yes",(IF(C2>D2,"No","Yes"))) then that would do it but it doesn’t. I still get a “Yes” when the measure and benchmark are equal. Can anyone help?

I attached the sample file.

Thanks.

[HWScott]

Please Login or Register  to view this content.

[HWScott]

Your post says "if the measure is less than or equal to the benchmark, it should return a “Yes”." That's what it's doing.

Please Login or Register  to view this content.

If you only want it to say Yes if the Rate is less than the benchmark:

Please Login or Register  to view this content.

[Iappreciate]

thanks. one other question, the data in the cell is in a number format and has 2 decimals (1.56) but when I click in the cell, it shows out to like 10 decimals (1.55871146518878).

Is there anyway to format it to read as 1.56 without doing it manually (I have many like this and don't want to do each one manually)? I think that's part of my issue.

Thanks

[Tony Valko]

If the number is the result of a formula then use rounding...

=ROUND(your formula,2)