 SOLVED

# 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.

3 Replies
best response confirmed by Fozzie85 (New Contributor)
Solution

# Re: Multiple formulas in a cell

=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?

# Re: Multiple formulas in a cell

=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

# Re: Multiple formulas in a cell

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.