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
Try:
=IF(B1<>"yes","",IF(A1="A","B",IF(A1="B","C","")))
Re: Multiple If And Statments
Way too cool. Thank you so much.
Brian
Don’t have an account yet? Register yourself now and be a part of our community!
