Formula Help

  • Thread starter Thread starter BBAL20
  • Start date Start date
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]))
 
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.
 
Back
Top