IF(ISError())

  • Thread starter Thread starter Harold
  • Start date Start date
H

Harold

I have been trying to use the IIF in combonation with the ISError.
But my results are not good. When "NewCal: IsError([CalSls]/[lost_sls])"
When the Lost_sls = 0 it generats an #Error, I am trying to get around the
Error result with this combonation of IIF (ISError) but it is not workning,

Looking for some help on what I can do. Also any idea why this does not
work?

New: IIf(IsError([NewCal]),1,2)
 
Use IIf instead - something like this:

NewCal: IIf([lost_sls] = 0, "ERROR", [CalSls]/[lost_sls])
 
Back
Top