Multiple IF function

Copper Contributor

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

Hi Esmeralda,

 

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

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)

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)

If collect the formulas one more variant

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