IF FORMULAS- using AND , OR

%3CLINGO-SUB%20id%3D%22lingo-sub-2310689%22%20slang%3D%22en-US%22%3EIF%20FORMULAS-%20using%20AND%20%2C%20OR%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2310689%22%20slang%3D%22en-US%22%3EI%20am%20needing%20help!%20What%20I%20am%20doing%20wrong.%20I%20am%20trying%20to%20calculate%20this%20formula%20and%20if%20both%20values%20are%20more%20or%20than%20equal%20to%20I%20must%20multiply%20them%20both%20by%2015%25%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2310689%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2310773%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20FORMULAS-%20using%20AND%20%2C%20OR%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2310773%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1041818%22%20target%3D%22_blank%22%3E%40cmcc182002%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20cannot%20produce%20results%20in%20two%20cells%20in%20one%20formula.%3C%2FP%3E%0A%3CP%3ECan%20you%20tell%20us%20where%20the%20results%20should%20go%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2310783%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20FORMULAS-%20using%20AND%20%2C%20OR%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2310783%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20added%20another%20image%20to%20show%20thanks.%20I%20am%20wanting%20the%20true%20answer%20to%20be%20either%2015%25*D4%20or%2015%25%20*E4%20for%20example%20and%20if%20not%20return%200%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2310830%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20FORMULAS-%20using%20AND%20%2C%20OR%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2310830%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1041818%22%20target%3D%22_blank%22%3E%40cmcc182002%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIn%20which%20cells%20do%20you%20want%20a%20formula%3F%20Please%20provide%20specific%20information.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2310867%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20FORMULAS-%20using%20AND%20%2C%20OR%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2310867%22%20slang%3D%22en-US%22%3ED24%20and%20D28%3C%2FLINGO-BODY%3E
New Contributor
I am needing help! What I am doing wrong. I am trying to calculate this formula and if both values are more or than equal to I must multiply them both by 15%
5 Replies

@cmcc182002 

 

You cannot produce results in two cells in one formula.

Can you tell us where the results should go?

I have added another image to show thanks. I am wanting the true answer to be either 15%*D4 or 15% *E4 for example and if not return 0

@cmcc182002 

In which cells do you want a formula? Please provide specific information.

D24 and D28

@cmcc182002 

It's very difficult to understand what you actually want.

Perhaps you can modify the following formulas to suit your purpose.

In D24: =IF(E4>E13,D4*15%,0)

And in D29: =IF(E9>E14,E4*15%,0)