K
Kyla2000
I am not sure how to fix this.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Bryan Hessey
Not much information to go on, can you post the statement?
If you are comparing two amounts, try comparing as
=If(Round(A1,2)=Round(A2,2),"True","False")
--
If you are comparing two amounts, try comparing as
=If(Round(A1,2)=Round(A2,2),"True","False")
--
K
Kyla2000
Thank you Bryan,
The rounding was the issue.
Thanks Again.
Lisa
The rounding was the issue.
Thanks Again.
Lisa
B
Bryan Hessey
Good to see, and thanks for the response.
Thank you Bryan,
The rounding was the issue.
Thanks Again.
Lisa
J
Jerry W. Lewis
A formula like
=(cell1-cell2)
will show why Bryan's solution was needed (note that the parentheses are
requrired).
Jerry
=(cell1-cell2)
will show why Bryan's solution was needed (note that the parentheses are
requrired).
Jerry