figure discounts

%3CLINGO-SUB%20id%3D%22lingo-sub-2352612%22%20slang%3D%22en-US%22%3Efigure%20discounts%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2352612%22%20slang%3D%22en-US%22%3E%3CP%3EHow%20can%20I%20figure%20a%20discount%20from%20one%20row%20of%20cells%20to%20another%3F%20I%20have%2035000%20different%20parts%20all%20with%20list%20price%20and%20need%20to%20have%20a%20cost%20Colum%20also.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2352612%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2356693%22%20slang%3D%22en-US%22%3ERe%3A%20figure%20discounts%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2356693%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1053326%22%20target%3D%22_blank%22%3E%40bob_rodgers1975%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYour%20post%20has%2031%20views%20and%200%20replies.%3C%2FP%3E%3CP%3Eyou%20need%20to%20share%20your%20issue%20and%20not%20keep%20it%20a%20secret%20so%20people%20can%20help%20you.%3C%2FP%3E%3CP%3Eif%20I%20asked%20you%20the%20same%20question%20you%20asked%26nbsp%3B%20and%20just%20showed%20you%20a%20picture%20like%20this%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Yea_So_0-1621054744069.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F280821iF2E06445C428722C%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Yea_So_0-1621054744069.png%22%20alt%3D%22Yea_So_0-1621054744069.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3Ewould%20you%20be%20able%20to%20answer%20your%20own%20question%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20show%20us%20which%20column%20u%20want%20your%20formula%20(the%20answer)%20so%20we%20can%20see%20where%20the%20values%20are%20then%20we%20can%20help%20you.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

How can I figure a discount from one row of cells to another? I have 35000 different parts all with list price and need to have a cost Colum also. 

1 Reply

@bob_rodgers1975 

 

Your post has 31 views and 0 replies.

you need to share your issue and not keep it a secret so people can help you.

if I asked you the same question you asked  and just showed you a picture like this:

Yea_So_0-1621054744069.png

would you be able to answer your own question?

 

Please show us which column u want your formula (the answer) so we can see where the values are then we can help you.