We'd like to remind Forumites to please avoid political debate on the Forum... Read More »
how to work out percentage in excel?
JohnSwift10
Posts: 442 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
- 349.7K Banking & Borrowing
- 252.6K Reduce Debt & Boost Income
- 452.9K Spending & Discounts
- 242.6K Work, Benefits & Business
- 619.4K Mortgages, Homes & Bills
- 176.3K Life & Family
- 255.5K Travel & Transport
- 1.5M Hobbies & Leisure
- 16.1K Discuss & Feedback
- 15.1K Coronavirus Support Boards