+ Reply to Thread
Results 1 to 2 of 2

if function problem.

  1. #1
    Registered User
    Join Date
    07-12-2008
    Location
    toronto
    Posts
    1

    if function problem.

    hi this if function is absurd. look at the picture. cell G185 to G188 are supposed to be true and 1. but for some reason it isn't. all cells are in number format, 2 dec point. look at the function bar for the formula. its same as other G cells.
    Attached Images Attached Images

  2. #2
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,675
    Excel compares the underlying value of the cells, not the number displayed.

    If, for example, G186 is 852.0001 and H186 is 851.9999 then when formatted to show 2 decimal places these will both display 852.00....but they aren't equal. If you want to compare the numbers rounded to 2 decimal places try

    =IF(ROUND(G186,2)=ROUND(H186,2),1,0)

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1