# Multiple IF function

Highlighted
Occasional Visitor

# Multiple IF function

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

# Re: Multiple IF function

Hi Esmeralda,

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

Highlighted

# Re: Multiple IF function

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

# Re: Multiple IF function

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

# Re: Multiple IF function

If collect the formulas one more variant

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