May 04 2020 12:06 PM
If I have a table that I want some rows to include a 10% markup but other rows not, is there a formula that is able to help me determine this? Basically I have a Yes or No column currently, and what I would like, is any row that is marked "Yes" would automatically get the 10% markup while the rows marked "No" would not get the markup. I'm not sure if it's possible or not, but figured I'd ask on here for some help before giving up.
Thanks!
May 04 2020 01:34 PM
it can be done by using if function, if you have a sample file share to us, may be best solution will be occured @HadInc9797
May 05 2020 10:20 AM
SolutionMay 05 2020 10:20 AM
SolutionThat would be:
=([@[10% Markup]]="Yes")*[@[Unit Cost]]*0.1