## Trending News

Promoted

# 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

- JoeBamaLv 78 years agoFavorite 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@XLLv 78 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.