# How to convert Fahrenheit to Celsius in Excel

Subtract 32 and multiply by 5/9 with `=(B2-32)*5/9`, or use `=CONVERT(B2,"F","C")`.

**Excel:** `=(B2-32)*5/9` (Every current version)

**Google Sheets:** the same formula works.

## Example

Sample data (row 1 is the header):

| A | B | C |
| --- | --- | --- |
| City | High (°F) | High (°C) |
| Phoenix | 107 |  |
| Chicago | 84 |  |
| Seattle | 72 |  |
| Miami | 91 |  |
| Denver | 88 |  |
| Anchorage | 65 |  |

Formula in C2, filled to C7: `=(B2-32)*5/9`

Result: 41.7; 28.9; 22.2; 32.8; 31.1; 18.3

## How it works

Water freezes at 32 °F and 0 °C, so subtract 32 first; then each Fahrenheit degree is 5/9 of a Celsius degree. 107 °F is 75 degrees above freezing, and 75 × 5/9 ≈ 41.7 °C. The parentheses make sure the subtraction happens before the multiplication.

## Other ways

- `=(B2-32)/1.8`: Dividing by 1.8 is the same as multiplying by 5/9.

## Common mistakes

- `=B2-32*5/9` without parentheses subtracts 17.8 from B2, which is wrong for every temperature.
- CONVERT's unit codes are case-sensitive: "F" and "C" work, "f" and "c" return #N/A.

## Questions

**How do I convert Celsius to Fahrenheit?**

Reverse it: `=B2*9/5+32`, or `=CONVERT(B2,"C","F")`.

**What else can CONVERT do?**

Lengths, weights, volumes and more: `=CONVERT(B2,"mi","km")` or `=CONVERT(B2,"lbm","kg")`.

Every formula and result on this page was checked by running it in the Spreadsheet Practice formula engine on 2026-10-30.

Source: https://spreadsheetpractice.com/formulas/convert-fahrenheit-to-celsius