Forum Discussion
Multiple formulas in a cell
I'm trying to do a formula for if the A cell says "specific text" and M cell says "yes" then run this formula but if the if the A cell has anything else and the M cell says "yes" then run another formula BUT if the M cell does not have "yes" then it would run another formula.
=IF(AND(A1="specific text",M1="yes"),AVERAGE(E9:E18),IF(AND(A1<>"specific text",M1="yes"),SUM(E9:E18),IF(AND(A1<>"specific text",M1<>"yes"),MAX(E9:E18),"")))
Is this what you are looking for?
3 Replies
=IF(AND(A1="specific text",M1="yes"),AVERAGE(E9:E18),IF(AND(A1<>"specific text",M1="yes"),SUM(E9:E18),IF(AND(A1<>"specific text",M1<>"yes"),MAX(E9:E18),"")))
Is this what you are looking for?
=IF(AND(A2="AEG",M2="YES"),SUM(N2*1.0625),IF(AND(A2<>"",M2="YES"),SUM(N2*1.0825),IF(AND(A2<>"",M2="NO"),N2)))
Here's the way I tried to put it in but it's not taking.
The 2nd and 3rd "specific text" can be anything- I'm not sure how/why it didn't work. Maybe I had a small typo in Excel but I copied exactly what I had here and pasted back in Excel and it worked! Thanks for the help.