Calculate the cost after percentage discount if percentage discount is populated

Stephanie Stewart

Hello all,

I have 3 columns in my Smartsheet List Price, Percentage Discount and Net Price. If the List Price and Percentage Discount are populated for a row, I'd the Smartsheet to determine the Net Price based off List Price and Percentage Discount. Some will not include a percentage, so I can't use =([List Price]1) - ([List Price]1) * [Percentage Discount]1. I need somekind of =IF(NOT(ISBLANK( formula.

Thanks in advance! This community is a LIFESAVER!

Stephanie Stewart

I think I got it :)

=IF(NOT(ISBLANK([Percentage Discount]1)), ([List Price]1 - ([List Price]1 * [Percentage Discount]1)))

SO far it seems to be working, but it anyone spots an error, please let me know.

Thanks!