IF function with 4 variables

[Bulge001]

Hi, could someone help me to get this function to work, it worked with 3 (see first line), but when I try with 4 it tells me I've added too many variables.

*I have removed some text from the return values*

3

=IF(AN11="";"";IF(AND(AN11=0;AN11>=0);"Unfortunately";"I am excited to announce that"&" "&AN11&" "& "€" &" "&"will be deducted from."))

4

=IF(AN11="";"";IF(AND(AN11=0;AN11>=0);"Unfortunately";"I am excited to announce that"&" "&AN11&" "&"€"&" "&"will be deducted from."));IF(AND(AN11="FULL");"I am excited to inform you that full, only will be charged.")

Thank you

[PaulM100]

Something like this maybe

=IF(AN11="","",IF(AN11="FULL","I am excited to inform you that full, only will be charged.",(IF(AND(AN11=0,AN11>=0),"Unfortunately","I am excited to announce that"&" "&AN11&" "&"€"&" "&"will be deducted from.")),IF(AN11="FULL","I am excited to inform you that full, only will be charged.")))

in your formula, the second IF has both conditions set, therefore it won't accept another nested IF.

[Bulge001]

It didn't work when I put that in in full, but did when I put it in as follows:

=IF(AN11="","",IF(AN11="FULL","I am excited to inform you that full, only will be charged.",(IF(AND(AN11=0,AN11>=0),"Unfortunately","I am excited to announce that"&" "&AN11&" "&"€"&" "&"will be deducted from."))

Thanks for the help!

[PaulM100]

That's great. Please mark the thread as Solved from Thread Tools, right corner, your first post. Thanks.