|
There are isolated problems with current patches, but they are well-known and documented on this site. |
Consider the following formula
ColA…..ColB…..ColC
1………….15………=A1>B1
A…………..15……..=A2>B2
C1 returns False, while C2 returns True. Does Excel automically convert the ’15’ to a string before the comparison? Is =N(A1)>N(B1) then the best formula to use for comparing 2 cells when one wants to ensure only numbers are compared?
Thanks
Donations from Plus members keep this site going. You can identify the people who support AskWoody by the Plus badge on their avatars.
AskWoody Plus members not only get access to all of the contents of this site -- including Susan Bradley's frequently updated Patch Watch listing -- they also receive weekly AskWoody Plus Newsletters (formerly Windows Secrets Newsletter) and AskWoody Plus Alerts, emails when there are important breaking developments.
