Help

Can IF use selected type

Topic Labels: Formulas
1331 4
cancel
Showing results for 
Search instead for 
Did you mean: 
Kc_chen
5 - Automation Enthusiast
5 - Automation Enthusiast

Hello everyone,

Sorry to bother you, but here’s a little question for the formula.

Can the selected function be used in the formula?
For example:

IF(argument 1 selected A, then count as xxxx, argument 2 selected B, Argument 2 Selected C then xxxx)

I’ve tried a few different ways, but it didn’t work.
Hope anyone can kindly give me some structure,

Thank you.

Best Regards,
K.c

4 Replies 4

Hmm, could you provide some example data and your desired output for said data?

For example, I have three types of tax status.

So when I select type A, it should counted as a formula,
when I select type B, it should be counted as b formula,
I select type C, it should be count as c formula.

Hope this could help, thank you so much.

Oh sure, here

Screenshot 2022-11-08 at 7.07.47 PM

Output field formula:

SWITCH(
  {Tax Status},
  "Type A", {Base Number} + 1,
  "Type B", {Base Number} + 2,
  "Type C", {Base Number} + 3
)

Thank you so much!!
It works.