SOLVED

Tables Question

%3CLINGO-SUB%20id%3D%22lingo-sub-1358531%22%20slang%3D%22en-US%22%3ETables%20Question%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1358531%22%20slang%3D%22en-US%22%3E%3CP%3EIf%20I%20have%20a%20table%20that%20I%20want%20some%20rows%20to%20include%20a%2010%25%20markup%20but%20other%20rows%20not%2C%20is%20there%20a%20formula%20that%20is%20able%20to%20help%20me%20determine%20this%3F%20Basically%20I%20have%20a%20Yes%20or%20No%20column%20currently%2C%20and%20what%20I%20would%20like%2C%20is%20any%20row%20that%20is%20marked%20%22Yes%22%20would%20automatically%20get%20the%2010%25%20markup%20while%20the%20rows%20marked%20%22No%22%20would%26nbsp%3B%20not%20get%20the%20markup.%20I'm%20not%20sure%20if%20it's%20possible%20or%20not%2C%20but%20figured%20I'd%20ask%20on%20here%20for%20some%20help%20before%20giving%20up.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1358531%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1358788%22%20slang%3D%22en-US%22%3ERe%3A%20Tables%20Question%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1358788%22%20slang%3D%22en-US%22%3E%3CP%3Eit%20can%20be%20done%20by%20using%20if%20function%2C%20if%20you%20have%20a%20sample%20file%20share%20to%20us%2C%20may%20be%20best%20solution%20will%20be%20occured%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F647269%22%20target%3D%22_blank%22%3E%40HadInc9797%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1359892%22%20slang%3D%22en-US%22%3ERe%3A%20Tables%20Question%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1359892%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F639126%22%20target%3D%22_blank%22%3E%40Khizar_Hayyat%3C%2FA%3E%26nbsp%3BPlease%20see%20the%20attached!%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1360918%22%20slang%3D%22en-US%22%3ERe%3A%20Tables%20Question%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1360918%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F647269%22%20target%3D%22_blank%22%3E%40HadInc9797%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThat%20would%20be%3A%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3E%3D(%5B%40%5B10%25%20Markup%5D%5D%3D%22Yes%22)*%5B%40%5BUnit%20Cost%5D%5D*0.1%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1361004%22%20slang%3D%22en-US%22%3ERe%3A%20Tables%20Question%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1361004%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1639%22%20target%3D%22_blank%22%3E%40Detlef%20Lewin%3C%2FA%3E%26nbsp%3BThank%20you%20so%20much!!%20It%20worked!!%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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!

4 Replies
Highlighted

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 

Highlighted

@Khizar_Hayyat Please see the attached! 

Highlighted
Best Response confirmed by HadInc9797 (New Contributor)
Solution

@HadInc9797 

That would be:

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

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