Forum Discussion

srutledge's avatar
srutledge
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 spreadsheet

excel

6 Replies

  • PReagan's avatar
    PReagan
    Bronze Contributor
    Oct 20, 2020

    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.

    • srutledge's avatar
      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

Resources