Formula tool IF statement-multiple conditiions

[hbland2]

I am getting error on the below formula. Please help.

IF[Age]>=180,IF([Age],365,IF(ABS([Amount in local cur.])<250000,[Amount in local cur.],0),0),)

Thanks!

[vizAlter]

@hbland2  — Can you attach your workflow with input data file, so that we could review?

What is the data type of your each field?

[grazitti_sapna]

Hi @hbland2 , check the datatype of the fields that you ar applying formula to.

Try using these datatypes mentioned above.

You are using double in your formula as datatype I believe the datatype of your field age is string that is why you are getting this error.

Thanks.

[ImadZidan]

Hello @hbland2 ,

This is todo with the age datatype in your data. It might be a string. 

IIF (ToNumber([Age])> 180 AND tonumber([Age]) <=365 and ABS([Amount in local cur.])<250000, [Amount in local cur.],0)