if(iserror not working for formula

[baindes]

Hello,

I can't get this function to work. Says I have too many arguments.

This is my formula:
D1417/(1+E1417/100)

and here is my revised that is giving me issues.

=if(iserror(D1417/(1+E1417/100),0,D1417/(1+E1417/100))

Thank you!

 

[Jonmo1]

You need to add one more )

=if(iserror(D1417/(1+E1417/100)),0,D1417/(1+E1417/100))

 

[Aladin Akyurek]

Hello,

I can't get this function to work. Says I have too many arguments.

This is my formula:
D1417/(1+E1417/100)

and here is my revised that is giving me issues.

=if(iserror(D1417/(1+E1417/100),0,D1417/(1+E1417/100))

Thank you!

Try one of:

=IF(ISNUMBER(1/E1417),D1417/(1+E1417/100),0)

=IFERROR(D1417/(1+E1417/100),0)

IsError is less appropriate here.

 

[baindes]

You need to add one more )

=if(iserror(D1417/(1+E1417/100)),0,D1417/(1+E1417/100))[/QUOTE

Worked perfect! thank you!

 

[Aladin Akyurek]

Just for the record: What is the reason you get an error?