Purple_Ichthyosaur's_Rule
New member
- Joined
- Nov 14, 2017
- Messages
- 4
- Reaction score
- 0
- Points
- 0
Hi Folks,
I've ran into a problem that seems to require having two "If" statements within the same custom column. Here is a very simplified example of the code:
=if [Price] = 25
then [Price] * 3
else [Price]
if [Price] = 26
then [Price] * 3
else [Price]
I can't figure out the syntax needed to join these two statements together. Is this even possible to have multiple "If" statements in the same custom column? I'm by no means a computer expert, so many apologies if this is annoyingly simple.
Best,
Andrew
I've ran into a problem that seems to require having two "If" statements within the same custom column. Here is a very simplified example of the code:
=if [Price] = 25
then [Price] * 3
else [Price]
if [Price] = 26
then [Price] * 3
else [Price]
I can't figure out the syntax needed to join these two statements together. Is this even possible to have multiple "If" statements in the same custom column? I'm by no means a computer expert, so many apologies if this is annoyingly simple.
Best,
Andrew