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

Reply