divison by zero error

K

khanner

this never used to show up till now.

'Compute Appraisal Value
If BBG("Orig# LTV").Value < 1 Then ltv = BBG("Orig# LTV").Value Else
ltv = BBG("Orig# LTV").Value / 100
loantape("OrigAppraisalValue").Value = CLng(BBG("Orig# Amt").Value)
/ CLng(ltv)
 
J

Jerry Whittle

If BBG("Orig# LTV").Value < 1
0 < 1 is true so you need to make sure that BBG("Orig# LTV").Value isn't 0.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

vba range in vlookup 4
Form Field Calculations 1
divison by zero 2
MS Office Update to Access 2003 3
Resizing/Rescaling an Org Chart 0
maybe by VBE users..... 4
excel date scheduling not msProject 0
SQL Hel---p 12

Top