Try rounding your calculation to a set number of dec places, either as you
calculate, or the final result, or even in the worksheet formula

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"John Pierce" wrote in message
om...
Here's my problem. I have a spreadsheet. There are some Named Ranges.
They are LoanAmount, PurchasePrice, AppraisedValue, and LTV.
I have a button on the sheet that calculates the LTV.
The code says:
Dim LoanAmount As Single, PurchasePrice As Single, etc
LoanAmount = Range("LoanAmount").Value etc
Range("LTV").Value = LoanAmount / AppraisedValue
I have a cell with the formula
=IF(LTV<"",IF(LTV80%,"PMI Needed","PMI NOT needed"))
However, when LoanAmount = 80,000 and AppraisedValue = 100,000
the value that appears in Range LTV is 80.000% (as formatted)
but I see "PMI Needed" because the real value of the calculation
is 80.0000011920928% which appears in the formula bar.
Any ideas?