SteveL13
asked on
Convert Excel formula that includes IfError to Access
I have an Excel formula that looks like:
=IFERROR((MAX((((G11-$M$5) *F11)*$M$6 ),0)),"")
The corresponding Access form fields are:
G11 = txtMST
M5 = txtMoistureMax
F11 = txtCleanCWT
M6 = txtDisSchd1
How do I convert this to Access?
=IFERROR((MAX((((G11-$M$5)
The corresponding Access form fields are:
G11 = txtMST
M5 = txtMoistureMax
F11 = txtCleanCWT
M6 = txtDisSchd1
How do I convert this to Access?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
This was perfect...
= IIf((Nz(txtMST, 0) - Nz(txtMoistureMax, 0)) * Nz(txtCleanCWT, 0) * Nz(txtDisSchd1, 0) >= 0, (Nz(txtMST, 0) - Nz(txtMoistureMax, 0)) * Nz(txtCleanCWT, 0) * Nz(txtDisSchd1, 0), 0)
= IIf((Nz(txtMST, 0) - Nz(txtMoistureMax, 0)) * Nz(txtCleanCWT, 0) * Nz(txtDisSchd1, 0) >= 0, (Nz(txtMST, 0) - Nz(txtMoistureMax, 0)) * Nz(txtCleanCWT, 0) * Nz(txtDisSchd1, 0), 0)
ASKER
And I'm going to post another formula issue titled, "Final Excel to Access calculation issue"
IIF ((((txtMST-txtMoistureMx)*