Multiple IF function

[uniontwp]

I need a formula to do the following:

If y156 is equals 1 then enter 0, if y156 equals 2 and s156 is greater than or equal to 0 then multiply s156 by 10 percent.

Thanks in advance for any assistance.

Tina

[BenjieLop]

I need a formula to do the following:

If y156 is equals 1 then enter 0, if y156 equals 2 and s156 is greater than or equal to 0 then multiply s156 by 10 percent.

Thanks in advance for any assistance.

Tina

See if this formula is what you need ...

=if(Y156=1,0,if(and(Y156=2,S156>=0),S156*0.1,""))

[uniontwp]

Thank you so very much for the formula. I was on the right track, just didn't know the AND I can't thank you enough.

[BenjieLop]

Thank you so very much for the formula. I was on the right track, just didn't know the AND I can't thank you enough.

You're welcome ... just glad I can help.

Regards.