How to subtract 23% in an excel sprees sheet what formula do I use if in cell a1 I have 1000 and I am looking?

To put answer in a2 cheers

2 Answers

Relevance
  • 8 years ago
    Favorite Answer

    =a1-(a1*0.23)

    The zero in front of the decimal point is not needed, but I was afraid if I did not put it there you would not see the decimal.

    Here is another way the formula can be entered.

    =a1-(a1*23/100)

  • IXL@XL
    Lv 7
    8 years ago

    Another way is to set out as follows

    A2 =A1*0.77 which is 100-23(%) ie 77% or 77% of 1000

Still have questions? Get your answers by asking now.