Data information with format:
Cell A2 $9,247.40
Cell B2 $75,612.99
Cell C2 $66,365.59
Cell D2: B2 - C2 The result is $9,247.40
Cell E1: =if(D1=A1,"Yes","No"). The result is coming as no instead of yes.
I have cleared the cells and entered the values again. I have also made sure the format was the same. Not sure what is causing the false response. I have attached the example.
Last edited by EAlden01; 02-04-2019 at 08:28 PM.
First 10 rows are hidden.
I've found data from your post in different columns in row 30, however:
Przechwytywanie.JPG
Happy with my answer * Add Reputation.
If You are happy with solution, please use Thread tools and mark thread as SOLVED.
I attached the wrong spreadsheet.
Przechwytywanie.JPG
You know why now?
Change D2 into:
Formula:
Please Login or Register to view this content.
and You will get YES :-)
Thank you it worked.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks