In Microsoft Excel, how do I make a formula for converting Fahrenheit to Celsius and for using percentage?
Favorite Answer
To convert from Fahrenheit to Celsius the conversion is: 1 celsius is equal to 33.80 fahrenheit or 1 fahrenheit is equal to -17.22 celsius
After you convert it with the formula you need to format the cell or column to percentage.
Once you have your formula working you can copy it to use elsewhere, if you copy it without the $ signs it will change to where it is pasted. If you put the $ into the formula it will be what is referred to as an absolute formula. Which basically means it will always use the cell you have the $ signs on and won’t move.
For ex. $a$1 * a2 will always use a1 and the a2 part will change to where you paste it. This is a method of putting the actual number you want to use to convert with in only once and allow it to change as you need it to elsewhere.
I hope this helps you.
C=(F-32)x5/9
- Academic Writing
- Accounting
- Anthropology
- Article
- Blog
- Business
- Career
- Case Study
- Critical Thinking
- Culture
- Dissertation
- Education
- Education Questions
- Essay Tips
- Essay Writing
- Finance
- Free Essay Samples
- Free Essay Templates
- Free Essay Topics
- Health
- History
- Human Resources
- Law
- Literature
- Management
- Marketing
- Nursing
- other
- Politics
- Problem Solving
- Psychology
- Report
- Research Paper
- Review Writing
- Social Issues
- Speech Writing
- Term Paper
- Thesis Writing
- Writing Styles