Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Code for 'unless"

Topic Labels: Formulas
165 1
cancel
Showing results for 
Search instead for 
Did you mean: 

Hey guys, so im working on an invoicing system.

I have three columns: Item Price, custom price, and applied price.

I’m in need of a formula for the applied price column that says "default to item price, but if custom price is > 0 use that custom instead.

any takers??

1 Reply 1
IF(
   {Custom price} > 0,
   {Custom price},
   {Item Price}
)