Forum Discussion
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.
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
.png){kind=link}