# Quick Base Discussions

View Only

## Formula help #### Mark Comish06-28-2018 00:22 #### QuickBaseCoach Dev./Training06-28-2018 00:40 • #### 1.  Formula help

Posted 06-28-2018 00:22
I need an If formula for the following...

If [field1] is equal to "CCO" then [field2]*.52
If [field1] is equal to "ASG-F" then [field2]*.20
If [field1] is equal to "ASG-K" then [field2]*.80
else [field2] is 0 or blank

Sorry but I am terrible at figuring out formula structures :-(

• #### 2.  RE: Formula help

Posted 06-28-2018 00:40
Because you are testing the same field and there are no other conditions, you can use CASE.

Case([field1],
"CCO", [field2]*.52,
"ASG-F", [field2]*.20,
"ASG-K", [field2]* .80)

The formula above will calculate to null if the above conditions are not met. A null is different than a zero.

If you do want the result to be a zero if the conditions are not met then use

Case([field1],
"CCO", [field2]*.52,
"ASG-F", [field2]*.20,
"ASG-K", [field2]* .80,0)

• #### 3.  RE: Formula help

Posted 06-28-2018 21:43
Thank you so much!

Mark