Add IFERROR to IF Statement with Multiple Conditions

[wsr429]

Hi, I would like to add an IFERROR to the beginning of my IF statement: IF(AND(A1="x",B1>=100),1.5,IF(AND(A1="y",B1<100),0,99))

I have tried to add the syntax for IFERROR, but the correct answer eludes me. I am using Excel for Mac Version 16.89.1.

Any help would be appreciated!

William

 

[DanteAmor]

But your formula could not return an error, unless one of cells A1 or B1 has an error, for example:

varios 26sep2024.xlsm
	A	B	C
1	a	#N/A
2
3	There is error here
4
Hoja2

Cell Formulas
Range	Formula
B1	B1	=NA()
A3	A3	=IFERROR(IF(AND(A1="x",B1>=100),1.5,IF(AND(A1="y",B1<100),0,99)),"There is error here")

Your formula is correct, if the first condition is met, it returns 1.5, if the second condition is met it returns 0, if no condition is met, then it returns 99.
If you are looking for some other value to be returned, then explain what the conditions would be for another value to be returned.

 

[wsr429]

Thank you @DanteAmor for your prompt reply. Your solution works great! I really appreciate your help.