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