Arg!
Hey guys. All i'm trying to do is have cell J3 indicate "Match" or "No Match" between cells I2 and I3. I've tried:
if(I2=I3,"Match","No Match") and EXACT(I2,I3) and I'm not getting consistently correct results. The formatting on the cells is identical, but the results are generated from various formulas.
Help!
Well, until we know precisely what's in each of those cells, including the formulas which generated them, we can't do much to help you!
Regards
Hi XOR
Okay:
I2=(IF(ISERROR(F2/(F2+G2)),"N/A",F2/(F2+G2)))*100
I3=(IF(ISNA(VLOOKUP(B1,'3 Sheet'!A:K,6,FALSE)),"N/A",VLOOKUP(B1,'3 Sheet'!A:K,6,FALSE)))
Both cells have Number formatting
Any ideas?
And what are the results of those two formulas?
Also, what do the following give:
=ISNUMBER(I2)
=ISNUMBER(I3)
?
Regards
XOR
The results are fractions which, when number formatting is added, give results to two decimal places.
isnumber(i2)=True
isnumber(i3)=True
Could you share the actual values with me? And I mean the actual values, not simply what is displayed as a result of whatever formatting you have on those cells (change the formatting back to e.g. General to reveal this)?
Regards
Sure, and thanks for your help thus far:
As an example:
I2=0.6666666667
I3=66.67
I figured its probably a formatting thing but i still can't get it to match
Not sure I understand.
The difference between those two values is approximately 60.
Regards
XOR
This is why i applied formatting to the two results. One one side the result comes out as a percentage, on the other the result is an implied percentage though without the actual percentage parts.
Formatting doesn't change the values in cells it just changes the appearance....that can be deceiving.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks