Create a userdefined function in Excel that will convert a t
Create a user-defined function in Excel that will convert a temperature measurement (not a temperature difference) to Celsius using any of the following formulas: °C = (5/9) (°F – 32) °C = K – 273 °C = (5/9) (°R – 492) Enter the temperatures in °F, K, and °R as optional arguments
Solution
Please find the excel workbook link : https://drive.google.com/open?id=0Byr5t30kJhKZbW41Z0ZibXdTa28
| Actual temperature | Temperature in F | Temperature in K | Temperature in R |
| 100 | 300 | 500 | |
| Converted Temperature | Temperature in C | Temperature in C | Temperature in C |
| 37.77777778 | 27 | 4.444444444 |
