lundi 23 avril 2018

Excel with 3 paramaters

Getting really desperate out here! I've read pretty much all the threads on this topic here but nothing seems to be working.

So, I need an IF function that would incorporate the following:

  • if b3=1, "Overbought"
  • if b3=2, "Neutral"
  • if b3=-1, "Oversold"

As said, I have tried few things such as nested IF functions but it always returns two of the three!!

Thanks a lot and I look forward to hearing from you guys!

Aucun commentaire:

Enregistrer un commentaire