Excel: the formula entered does not return any results

You are working on a sheet Excel ma the formula entered does not return any results? The Excel file was sent to you and was created by someone else and you can't figure out the cause?

Don't worry, keep reading and I'll explain why the formula entered in Excel does not return any results.

You need to know that there can be two solutions to this problem:

The first, if the file was not created by you, it could be that the Display of formulas in cells instead of calculated results is active. In this case you have to go, on your Excel sheet (from version 2007 onwards), to File> Options> Advanced Settings and, scrolling down with the scroll bar, locate the section Display options for the worksheet.

You should see the entry in the list Display formulas in cells instead of calculated results, if the box has a tick, all you have to do is remove it and confirm by clicking on the button OK.

In case the box concerning the item Display formulas in cells instead of calculated results does not have a tick, there is another solution.

The second solution is to resort to this trick.

Select all the column on which the formula entered and not calculated is already present

In the top menu, in the section Data, press the icon Text in columns

A window called "Text to Column Wizard“, Put a tick here, if there is not already up Delimited e premium pulsating NEXT.

In the next step, check that the item is checked Tabulation and press the button again NEXT.

In the last step, in data format by column, put the check mark on General e premium pulsating end.

The formula that didn't work like magic before should give you the calculated result.