Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 26, 2021 02:43 PM
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
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 26, 2021 05:45 PM
IF(
{Custom price} > 0,
{Custom price},
{Item Price}
)
Reply