Share via

function issue

Art King 0 Reputation points
2026-03-19T22:05:13.8733333+00:00

Function does not always calcualte in some cells. for example when I do the simple formula of d24/3

Microsoft 365 and Office | Excel | For home | Windows
0 comments No comments

1 answer

Sort by: Most helpful
  1. Arlene D 36,020 Reputation points Independent Advisor
    2026-03-19T23:16:17.0433333+00:00

    Hi,

    Are the affected cells formatted as Text or General?

    If Excel does not calculate a formula like =D24/3, it is often due to cell format or calculation settings. Select the cell, then go to Home, Number group, and set it to General, then press F2 and Enter to force recalculation. Also check Formulas tab, Calculation Options, and set it to Automatic. If the formula still shows as text, remove any leading apostrophe before the equals sign and re-enter the formula.

    0 comments No comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.