Oct 23 2017
09:18 PM
- last edited on
Jul 25 2018
10:16 AM
by
TechCommunityAP
Oct 23 2017
09:18 PM
- last edited on
Jul 25 2018
10:16 AM
by
TechCommunityAP
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.
Oct 24 2017 02:58 AM
Hi Esmeralda,
In formula on your picture you compare M2949, not M2984. What is in it?
Oct 25 2017 01:04 PM
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)
Oct 25 2017 01:10 PM
Oct 25 2017 03:30 PM
If collect the formulas one more variant
=SUM(COUNTIF(M2984,{"bollinger","gifi","performance"}))*K2984*AE2984/100