Tables Question

[HadInc9797]

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!

[#2]

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 

[#3]

@Khizar_Hayat Please see the attached! 

[#4 · Accepted solution]

@HadInc9797 

That would be:

=([@[10% Markup]]="Yes")*[@[Unit Cost]]*0.1

[#5]

@Detlef Lewin Thank you so much!! It worked!!