Oct 20 2020 10:29 AM
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
Oct 20 2020 11:05 AM
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.
Oct 20 2020 11:30 AM
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
Oct 20 2020 11:46 AM
Oct 20 2020 12:06 PM
@PReagan yes thats it. what line do I select to enter the formula
Oct 22 2020 07:54 AM
Cell B2 contains the formula in the formula bar. Cell C2 contains the formula:
=A2-B2
All other values were manually entered.