# Multiple If And Statments

• I have searched the site and havent found exactly what I am looking for.

I am trying to us and IF(AND) statement multiple times. I have a cell that is dependent on two cells above and have been using an IF AND that if B1=YES and A1=A then A2=B. But I want to add multiples to this because if A1 is already equal to B I want it to equal C. Finally, if B1=NO I want to return an empty cell.

Any Ideas?

thanks,
Brian

• Re: Multiple If And Statments

You are mentioning more than one cell to be changed. You can only change the cell that the formula is in. Try to explain again. Which cell is the formula in, and if then else conditions.

• Re: Multiple If And Statments

ok.

cells A1 & B1 have the info. THe equation will be in A2. For any thing to happen, B1 has to be yes. if it is not I need to return a blank cell to A2. If B1 is yes, and A1=A, i need A2=B. If B1 is yes and A1=B, I need A2=C.

Hope that makes more sense.

Thanks,
Brian

• Re: Multiple If And Statments

Way too cool. Thank you so much.
Brian

## Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!