Help

Can there be a formula in the IF?

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

Hello Everyone,

I am a gallery assistant and trying to convince my director to move to Airtable!
However, I meet some issues, hope anyone can kindly help me.

So there will be two groups of product prices, one is (A+B), and the other one will be the amount we type in.

Can the formula do something like If(Checkbox=1, “{A+B}”, “manual enter”) or something like this?
Sorry really bad at this.

Hope anyone can give me some ideas about this

2 Replies 2
Zack_S
8 - Airtable Astronomer
8 - Airtable Astronomer

Hi @Kc_chen,

Yes, you have a few options. I would suggest creating a field/column named ‘Manual Price’ and create your Formula field.

In the formula field use IF({Manual Price}, A+B, {Manual Price})

You can then format the formula field to display in a currency format.

Kc_chen
5 - Automation Enthusiast
5 - Automation Enthusiast

Thank you so much that does help!!