Nested if statements

[srmorgan]

I just can't seem to get this right.

I have two conditions,

Balance Days Action
>$1500 >1200 "Keep"
>$1500 <1200 "Remove"
<$1500 >840 "Keep"
<$1500 <840 "Remove"

I know this is simple but I can't get it right

Thank you

 

[Person93]

=if(condition1=true,if(condition2=true,errormessage),errormessage)

 

[Daveydoodles]

With your data in columns A & B, this seems to work

=IF(A1>1500,IF(B1>1200,"Keep","Remove"),IF(B1>840,"Keep","Remove"))

 

[srmorgan]

That worked. Thank you.

SRM