Hi everyone, first post so apologies if i'm in the wrong area of the forum.
I'm trying to calculate percentage remaining.
I have the following.
Cell B29 £1541.05 and Cell B30 £1098.10.
I have done =B30/B29 to give the "percentage used" of 71.26% displayed in cell B34
How do I get the remaining "percentage available" 28.74% to display in cell B35?
I'm sure i'm probably just being a bit thick as I managed to do the first one fine.
Thanks.
= 1 - b30/b29
?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
― Robert A. Heinlein
Maybe this?
=B29-B34
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
...
1-b34
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
I tried the first answer and that worked perfect.
I'll give the others a try and see what happens.
Thank you.
I confirm that the first answer works perfectly.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks