Hello. I have a cell with what I believe are identical values. I write this formula =C11=D5 but it comes up as false. Am I writing formula wrong dong?
Hello. I have a cell with what I believe are identical values. I write this formula =C11=D5 but it comes up as false. Am I writing formula wrong dong?
2 thing to look at:
Are there any spaces in one of the cells?
Is there a number formated as text?
Upload your file for better and faster help.
Willem
English is not my native language sorry for errors
Please correct me if I'm completely wrong
Also is one a VALUE but the other a TEXT.
Please ensure you mark your thread as Solved once it is. Click here to see how.
If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.
Also, check how many decimals are displayed:Please Login or Register to view this content.
C11 = 1.0001
D5 = 1.0000
But if they are formatted to two decimals of precision, they will both display 1.00 while still being different numbers.
Click the [* Add Reputation] Button to thank people for help!
Post Attachment: Click [Go Advanced] under the reply box; then click [Manage Attachments] to launch the attachments dialogue.
Mark Thread Solved: Go to the top of the first post; Select [Thread Tools] dropdown; Pick the [Mark thread as Solved] option.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks