SOLVED

Multiple formulas in a cell

%3CLINGO-SUB%20id%3D%22lingo-sub-3071637%22%20slang%3D%22en-US%22%3EMultiple%20formulas%20in%20a%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3071637%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20trying%20to%20do%20a%20formula%20for%20if%20the%20A%20cell%20says%20%22specific%20text%22%20and%20M%20cell%20says%20%22yes%22%20then%20run%20this%20formula%20but%20if%20the%20if%20the%20A%20cell%20has%20anything%20else%20and%20the%20M%20cell%20says%20%22yes%22%20then%20run%20another%20formula%20BUT%20if%20the%20M%20cell%20does%20not%20have%20%22yes%22%20then%20it%20would%20run%20another%20formula.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3071637%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

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

@Fozzie85 

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