IFS/AND but has input of invalid type unknown?

[Raynian]

Hi all!

I am trying to create a tax contribution calculator where somebody can enter their gross salary and age and the calculated virtual column will calculate based on their age, the contribution amount.

I am using the formula
=[Gross Salary]*ifs([Age]<=55, “0.2”, AND([Age]>55, [Age]<=60), “0.13”, AND([Age]>60, [Age]<=65), “0.075”, [Age]>65, “0.05”)

The tax amount for someone with age <=55 is 20%, Age between 56 and 60 being 13%, age between 61 and 65 being 7.5% and lastly if age > 65 being 5%

However on inputing this into the column formula it tells me that

Arithmetic expression ‘([Gross Salary]*IFS(([Age] <= 55),“0.2”,AND(([Age] > 55), ([Age] <= 60)),“0.13”,AND(([Age] > 60), ([Age] <= 65)),“0.075”,([Age] > 65),“0.05”))’ has inputs of an invalid type ‘Unknown’

Anybody has any idea on what I can do about this? Thank you so much!

[Suvrutt_Gurjar]

Please try to remove double quotes around multipliers. Instead of “0.2” , please simply try 0.2
Double quotes convert the numerical value into a text.

Please also ensure, the VC storing result is of either price or decimal type, as required.