View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Anisette Anisette is offline
external usenet poster
 
Posts: 3
Default Formula does not calculate - Have tried F9

I have a very simple problem that is frustrating me...

I have an existing column of numbers and they Format/Cells/Number/General
assigned to them.
Over to the side I have a series of IF functions, each one comparing the
value of each cell of numbers with a defined limit.
The IF function only works when I go in to each cell in my column of numbers
and hit return.

I have more than 5000 entries, so I am desperate to find a way of getting
the IF function to recognise the numbers and give a result without having to
hit Enter on every number.

I have checked Tools/Options/Calculation and Automatic is ticked. I have
set it to manual, and then set it back to Automatic just to be sure.

I have also hit F9, Ctl+F9, Ctl+Alt+F9, Ctl+Alt+Shift+F9 - but no joy.

Any ideas?