Code for 'unless"

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

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.