Formula Help

B

BBAL20

Can someone help me with the formula below. I can't figure out what I'm doing
wrong.


IIf(IsError([Label43] / [Text91]),"-", IIf(([Label43] / [Text91]=0,"-",
[Label43] / [Text91]))
 
D

Duane Hookom

Label controls don't have values. They have captions.
If you are attempting to fix divide by 0 errors, the general syntax is:
=IIf([SomeValue] = 0 , Null, [OtherValue]/[SomeValue])

BTW: do yourself a favor and rename your controls to values that provide
some self-documentation.
 

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

MS Project. Real progress of the project, % complete 1
Help with Iif on Report 4
Save Current Record; Go To Next Record - two tables in form 1
Printer Page & Drawing Page 0
Macro to select and delete levels of a document 2
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Mail Merge Switch - Dollars to Words 0
Newbie Help - IF Yes No Function 0

Top