Calculate the cost after percentage discount if percentage discount is populated
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!