We’d like to remind Forumites to please avoid political debate on the Forum.
This is to keep it a safe and useful space for MoneySaving discussions. Threads that are – or become – political in nature may be removed in line with the Forum’s rules. Thank you for your understanding.
📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!
The Forum now has a brand new text editor, adding a bunch of handy features to use when creating posts. Read more in our how-to guide
XL Spreadsheet Percentage Formula Question
stone7
Posts: 2,464 Forumite
in Techie Stuff
Hi All.
In cell A1 I have 100(£). I want cell B1 to show the value of cell A1 minus 20%.
... I've tried, [=A1-20%] and get nothing like the right answer.
Any ideas much appreciated.
In cell A1 I have 100(£). I want cell B1 to show the value of cell A1 minus 20%.
... I've tried, [=A1-20%] and get nothing like the right answer.
Any ideas much appreciated.
0
Comments
-
Try
=(0.8*A1)
Since 0.8 x A1 is equal to A1 minus 20%Squirrel!If I tell you who I work for, I'm not allowed to help you. If I don't say, then I can help you with questions and fixing products. Regardless, there's still no secret EU law.
Now 20% cooler0 -
Try
=(0.8*A1)
Since 0.8 x A1 is equal to A1 minus 20%
That is fine but not very useful if you change the percentage.
You could use =A1-(A1*20%)
This way you could just change the percentage by editing the formula.
A better way would be to enter the percentage as a number in another cell, say C1.
Then use the formula =A1-(A1*C1%)
This way you can change the percentage without editing the formula, just change the number in cell C1.
Make sure that cell C1 is formatted as a number (the default format) and not a percentage or it won't work, the percentage bit is done in the formula you entered in cell B1.0 -
That is a complex way of going about it.
If:
A1 is your original number
B1 is your variable percentage figure (format the cell as percentage)
C1 is your answer
Then:
Cell C1 just contain the simple formula =A1*B10 -
That is a complex way of going about it.
If:
A1 is your original number
B1 is your variable percentage figure (format the cell as percentage)
C1 is your answer
Then:
Cell C1 just contain the simple formula =A1*B1
That doesn't give what the OP was after.
For an original no. of 100 the result of your formula gives the result as 20 ie 20% of 100.
The OP was after 100 minus 20% which is 80. You have over simplified your formula.0 -
Yes, OK - late at night, not reading ...
In which case:
Cell C1 just contain the formula =A1*(1-B1)0
This discussion has been closed.
Confirm your email address to Create Threads and Reply
Categories
- All Categories
- 353.6K Banking & Borrowing
- 254.2K Reduce Debt & Boost Income
- 455.1K Spending & Discounts
- 246.7K Work, Benefits & Business
- 603.1K Mortgages, Homes & Bills
- 178.1K Life & Family
- 260.7K Travel & Transport
- 1.5M Hobbies & Leisure
- 16K Discuss & Feedback
- 37.7K Read-Only Boards