Hi,
I have an issue with IF formula as explained below.
A1=102.10
B1=102.103
C1=IF(A1=B1,"EQUAL","UN EQUAL")
All the 3 cells are formatted to general.I just want excel to consider only 2 decimals for equation.I just want to ignore the 3rd decimal in Cell "B1".
If that's the case the result should show "EQUAL".
How can i achieve that? Can anyone help me?
Thanks,
Netaji
There will be lots of ways of doing this. Here's one:
=IF(INT(A1*100)/100=INT(A2*100)/100,"EQUAL","UN EQUAL")
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
Try
=IF(ROUND(A1,2) = ROUND(B1,2), "EQUAL","UNEQUAL")
Thank you Glenn and Mrice.
Both the solutions worked like charm.
Thanks once again.
Netaji
Thanks, and you're welcome1
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Netaji 
Register To Reply
Bookmarks