Forum Discussion

Copper Contributor

Oct 20, 2020

formula question

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

excel

srutledge

Copper Contributor

Oct 20, 2020

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

srutledge

Copper Contributor

Oct 20, 2020

the minus 10% should be divided by 10%

PReagan
Bronze Contributor
Oct 20, 2020
srutledge

If I am understanding correctly, that could be something like this:
- srutledge
  Copper Contributor
  Oct 20, 2020
  PReagan yes thats it. what line do I select to enter the formula
  - PReagan
    Bronze Contributor
    Oct 22, 2020
    srutledge
    
    Cell B2 contains the formula in the formula bar. Cell C2 contains the formula:
    =A2-B2
    All other values were manually entered.