Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calculation
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multi threaded calculation (multi CPU) - impact on calculation spe | Excel Discussion (Misc queries) | |||
age calculation | Excel Discussion (Misc queries) | |||
How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
range.calculation with UDF not working when calculation is set to automatic | Excel Programming |