Tushar,
I tried what you said but only 70.65 was in the cell and I even increased
the decimal placing to 10 places and no visual difference.
Still bemused as other formulas are not having this problem.
--
KRAMER
"Tushar Mehta" wrote:
Change the format of the two cells to 'General'. Now, what do the 2
cells contain? Double the column width. What do the cells contain?
--
Regards,
Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
In article ,
says...
Hi Guy's,
I don't know if I've done something wrong or what, but, I have a sum in one
book and a different sum in another. I am using the IF function to basically
tell me when the two results differ. Now the results are the same e.g.
"$70.65" but the function =IF(H22=[book1]jun!D22," ","check book1jun") is
showing false when I know that both cells equal "$70.65". I double checked by
removing the sum from cell H22 and typing 70.65 (formatted as currency of
course) and the function then says true. I am using IF function to match
other sum results and no problem.
Pease help I am really freaked about this!!