Excel Table with formula not calculating

I have an Excel spreadsheet turned into table.

I have a column that's populated with a formula, but when I entered data the formula is not calculating.

enter image description here

As you can see, column [AgeGroup] does not calculate for column [Age] in the second row.

4

1 Answer

have to turn on calculation options -> automatic

enter image description here

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password

Post as a guest

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

You Might Also Like