We'd like to remind Forumites to please avoid political debate on the Forum... Read More »
We're aware that some users are experiencing technical issues which the team are working to resolve. See the Community Noticeboard for more info. Thank you for your patience.
📨 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!
how to work out percentage in excel?
Options
JohnSwift10
Posts: 489 Forumite
in Techie Stuff
I have a sensor that reads 314 when wet and 144 when dry.
If the sensor reads 229 (50%) what formula do I need to show what the percentage is if 314 is 100% and 144 is 0% and how do I "convert" 314 to 100% and 144 to 0%?
If the sensor reads 229 (50%) what formula do I need to show what the percentage is if 314 is 100% and 144 is 0% and how do I "convert" 314 to 100% and 144 to 0%?
0
Comments
-
=(reading-144)/(314-144) will give an answer between 0 and 1.Format that cell as a percentage and you're done.
I’m a Forum Ambassador and I support the Forum Team on the In My Home MoneySaving, Energy and Techie Stuff boards. If you need any help on these boards, do let me know. Please note that Ambassadors are not moderators. Any posts you spot in breach of the Forum Rules should be reported via the report button, or by emailing forumteam@moneysavingexpert.com.
All views are my own and not the official line of MoneySavingExpert.
1
Confirm your email address to Create Threads and Reply
Categories
- All Categories
- 350.8K Banking & Borrowing
- 253.1K Reduce Debt & Boost Income
- 453.5K Spending & Discounts
- 243.8K Work, Benefits & Business
- 598.7K Mortgages, Homes & Bills
- 176.8K Life & Family
- 257.1K Travel & Transport
- 1.5M Hobbies & Leisure
- 16.1K Discuss & Feedback
- 37.6K Read-Only Boards