Multiple IF function

%3CLINGO-SUB%20id%3D%22lingo-sub-119421%22%20slang%3D%22en-US%22%3EMultiple%20IF%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-119421%22%20slang%3D%22en-US%22%3E%3CP%3EWhat%20the%20formula%20be%20if%20I%20want%20the%20cell%20to%20be%20if%20m2984%3D%22bollinger%22%20or%20%22performance%22%20or%20%22gifi%22%20to%20multiply%20AI2984*K2984%3F%20PLEASE%20and%20THANK%20YOU.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-119421%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20Desktop%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20%26amp%3B%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-120980%22%20slang%3D%22en-US%22%3ERe%3A%20Multiple%20IF%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-120980%22%20slang%3D%22en-US%22%3E%3CP%3EIf%20collect%20the%20formulas%20one%20more%20variant%3C%2FP%3E%3CPRE%3E%3DSUM(COUNTIF(M2984%2C%7B%22bollinger%22%2C%22gifi%22%2C%22performance%22%7D))*K2984*AE2984%2F100%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-120920%22%20slang%3D%22en-US%22%3ERe%3A%20Multiple%20IF%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-120920%22%20slang%3D%22en-US%22%3EIn%20case%20you%20are%20working%20on%20the%20same%20row%2C%20otherwise%20adjust%20the%20numbers%20in%20the%20formula.%3CBR%20%2F%3EYou%20can%20use%20one%20IF%20only%20in%20addition%20to%20OR%20function%20which%20is%20simpler%3CBR%20%2F%3E%3CBR%20%2F%3E%3DIF(OR(M2984%3D%22bollinger%22%2CM2984%3D%22gifi%22%2CM2984%3D%22performance%22)%2CK2984*AE2984%2F100%2C0)%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-120916%22%20slang%3D%22en-US%22%3ERe%3A%20Multiple%20IF%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-120916%22%20slang%3D%22en-US%22%3E%3CP%3EIn%20case%20you%20are%20working%20on%20the%20same%20row%2C%20otherwise%20adjust%20the%20numbers%20in%20the%20formula.%3C%2FP%3E%3CP%3EYou%20can%20use%20one%20IF%20only%20in%20addition%20to%20OR%20function%20which%20is%20simpler%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DIF(OR(M2984%3D%22bollinger%22%2CM2984%3D%22gifi%22%2CM2984%3D%22performance%22)%2CK2984*AE2984%2F100%2C0)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-119505%22%20slang%3D%22en-US%22%3ERe%3A%20Multiple%20IF%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-119505%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Esmeralda%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20formula%20on%20your%20picture%20you%20compare%20M2949%2C%20not%20M2984.%20What%20is%20in%20it%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

What the formula be if I want the cell to be if m2984="bollinger" or "performance" or "gifi" to multiply AI2984*K2984? PLEASE and THANK YOU.

4 Replies
Highlighted

Hi Esmeralda,

 

In formula on your picture you compare M2949, not M2984. What is in it?

Highlighted

In case you are working on the same row, otherwise adjust the numbers in the formula.

You can use one IF only in addition to OR function which is simpler

 

=IF(OR(M2984="bollinger",M2984="gifi",M2984="performance"),K2984*AE2984/100,0)

Highlighted
In case you are working on the same row, otherwise adjust the numbers in the formula.
You can use one IF only in addition to OR function which is simpler

=IF(OR(M2984="bollinger",M2984="gifi",M2984="performance"),K2984*AE2984/100,0)
Highlighted

If collect the formulas one more variant

=SUM(COUNTIF(M2984,{"bollinger","gifi","performance"}))*K2984*AE2984/100