Help

Code for 'unless"

Topic Labels: Formulas
458 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Lake_Wilkinson
4 - Data Explorer
4 - Data Explorer

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}
)