Skip to main content

Code for 'unless"

  • May 26, 2021
  • 1 reply
  • 9 views

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

Kamille_Parks11
Forum|alt.badge.img+27
IF(
   {Custom price} > 0,
   {Custom price},
   {Item Price}
)