Formulas Not Evaluating?

Hi,

I've having an issue with formulas not evaluating. I enter in the correct formula (as far as I know) and then press enter. But the text for the formula still stays the same.

It's not working for normal formulas either.

I've done some Googling and people are saying that the issue is commonly due to Show Formulas being selected. But in my case it isn't selected .

Any idea what the issue might be?

Any help is really appreciated, thank you.

Figured it out! The cell was set to Text instead of a number. Silly mistake :slight_smile:

1 Like