Skip to main content
Question

Case/if

  • May 6, 2020
  • 0 replies
  • 97 views

I am running into an issue with the following formula…. please help.



------------------------------
Brandy Nunes
------------------------------
This topic has been closed for replies.

  • Registered
  • May 6, 2020
In the future it is almost always easier if you post the actual text of your formula and also any errors it is giving you.

You only need to have 1 IF at the end of the formula there. without seeing the error it looks like to me that your IFs are the problem. Your first IF in the formula is set up as the only IF. Your IF needs a condition, an action to take if it is true, and then a false for a single line. If you want multiple lines then the false needs to be the next line, which I am finding is hard to explain through text. Hopefully the below example explains it well enough.

IF(
[condition]=[whatever], [if True do this],
[condition]=[something], [if True do this2],
[condition]=[purple], [if True do this3], [if False do this]
)