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.
4 Replies
- 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
Hi Esmeralda,
In formula on your picture you compare M2949, not M2984. What is in it?
.png){kind=link}