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])
 

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

Expression Builder query with zero amounts 5
How do you substitue a value for #Error 4
How to use IsError()? 1
#Error Help Needed 2
IIf(IsError... 4
Text to Time converstion problem 2
IsError function 1
Data Conversion Expression returns #Error 2

Back
Top