formula question

Copper 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.