formula question

%3CLINGO-SUB%20id%3D%22lingo-sub-1800498%22%20slang%3D%22en-US%22%3Eformula%20question%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1800498%22%20slang%3D%22en-US%22%3E%3CP%3EIs%20there%20a%20way%20to%20separate%20a%20%25%20dollar%20amount%20and%20minus%20dollar%20amount%20on%20same%20spreadsheet%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eexample%20is%20I%20have%20a%20fee%20of%20%24495%20for%20one%20client%20and%20the%20next%20is%20only%2010%25%20how%20can%20I%20put%20that%20on%20one%20spreadsheet%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1800498%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1800637%22%20slang%3D%22en-US%22%3ERe%3A%20formula%20question%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1800637%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F839565%22%20target%3D%22_blank%22%3E%40srutledge%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20afraid%20you%20will%20have%20to%20clarify%20on%20your%20problem.%20In%20general%2C%20you%20can%20put%20your%20fee%20in%20one%20cell%20and%20your%20additional%2010%25%20fee%20in%20the%20next%20cell.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1800740%22%20slang%3D%22en-US%22%3ERe%3A%20formula%20question%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1800740%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F360420%22%20target%3D%22_blank%22%3E%40PReagan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eexample%20I%20have%20certain%20fees%20to%20be%20taken%20out%20for%20money%20received.%20some%20are%20minus%20a%20dollar%20amount%20and%20some%20are%20minus%2010%25%20I%20wanted%20to%20create%20a%20spreadsheet%20that%20reflected%20the%20amount%20due%20if%20I%20just%20enter%20the%20dollar%20amount%20or%20the%20percentage%20without%20having%20to%20do%20the%20formula%20everytime%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1800804%22%20slang%3D%22en-US%22%3ERe%3A%20formula%20question%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1800804%22%20slang%3D%22en-US%22%3Ethe%20minus%2010%25%20should%20be%20divided%20by%2010%25%3C%2FLINGO-BODY%3E
New Contributor

Is there a way to separate a % dollar amount and minus dollar amount on same spreadsheet  

 

example is I have a fee of $495 for one client and the next is only 10% how can I put that on one spreadsheet

6 Replies

Hello @srutledge,

 

I'm afraid you will have to clarify on your problem. In general, you can put your fee in one cell and your additional 10% fee in the next cell.

@PReagan 

 

example I have certain fees to be taken out for money received. some are minus a dollar amount and some are minus 10% I wanted to create a spreadsheet that reflected the amount due if I just enter the dollar amount or the percentage without having to do the formula everytime

the minus 10% should be divided by 10%

@srutledge 

 

If I am understanding correctly, that could be something like this:

PReagan_0-1603219537771.png

@PReagan yes thats it. what line do I select to enter the formula

 

@srutledge 

 

Cell B2 contains the formula in the formula bar. Cell C2 contains the formula:

=A2-B2

All other values were manually entered.