Skip to main content

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??

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