I'm trying to match cells by cell using the IF function. For some reason the top example in the spreadsheet is not matching, while the bottom example is matching. I removed all the formatting and made sure the AM and PM's match, but for some reason it is still showing up as not matching. Can anyone explain?
Where did you copy these values from? They are formatted to APPEAR as time values, but under the hood they are still nothing more than long decimals. Set the format to GENERAL and expand the decimal places and you'll see the variances.
In terms of time, both of these values display as 5:25 PM
A2: 0.725694444444444
B2: 0.725694444444445
That's a difference of literally milliseconds in time, but they still aren't the same value. That's why i asked where they are coming from? If you manually enter 5:25 PM into two cells, the same value is entered. But that's not the case with this data.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
Hi the top two sets of numbers are not in fact the same. They differ at the 15th decimal place. i.e.
A1: 0.711805555555556
B1: 0.711805555555555
ditto A2 & B2
Regards
Richard Buttrey
If this was useful then please rate it appropriately.
Click the small star iconat the bottom left of my post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks