Comparing 2 results (one from formula) showing not equal when it is really equal?

**g1terra** · 06-10-2017, 04:39 PM

Hello, I am writing a conditional formula to highlight when a result of another formula is > or < another compared number. The issue I am having is its highlighting when its equal. i know it has something to do with binary something or other but I am really stuck..

Here is the formula

=IF(Z16>G16,1,0)

In another situation I created a helper cell and used the ROUNDUP function. I really cant do with this it will take more work than I care do do for this feature. Is there a function that helps in this case? Thx in advance!

**TMS** · 06-10-2017, 04:42 PM

Use ROUND/ROUNDUP in your CF formula.

**MarvinP** · 06-10-2017, 04:58 PM

Hi,

Like TMS suggests...

=IF(Round(Z16,0)>Round(G16,0),1,0)

Comparing 2 results (one from formula) showing not equal when it is really equal?

LinkBack

Thread Tools

Rate This Thread

Display

Comparing 2 results (one from formula) showing not equal when it is really equal?

Re: Comparing 2 results (one from formula) showing not equal when it is really equal?

Re: Comparing 2 results (one from formula) showing not equal when it is really equal?

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] COUNTIFS function w/greater than or equal to, and less than or equal to time values

[SOLVED] Showing 2 cells as equal within a certain percentage

Scoresheet with Equal Ranks - need to identify equal placings separately

[SOLVED] equal to formula not returning right results =IF($E3<=G$1,O3,0)

when is equal not equal - cell reference results to blank cell

Formula function for ignoring cells/results equal to 0 (zero) ?

[SOLVED] Conditional Sum Argument results do not equal cell results Excel

Bookmarks

Bookmarks

Posting Permissions