MAX function

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

I am using the following formula =MAX(Revenue!L689:L694)+6 and it seems to be
hubg up as the cell shows only the formula, no result. I've checked
formatting for the cells, etc., but no go. The numbers being referenced are
years (2010, 2006, 2007, 2008, etc), so this should be an easy calc. Is
there a bug out there?
 
Chris said:
I am using the following formula =MAX(Revenue!L689:L694)+6 and it seems to be
hubg up as the cell shows only the formula, no result. I've checked
formatting for the cells, etc., but no go. The numbers being referenced are
years (2010, 2006, 2007, 2008, etc), so this should be an easy calc. Is
there a bug out there?
Click to expand...


Make sure the cell is formatted as 'General', and re-enter the formula...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

max and calculated cells 1
Is that possible; More than one Formula 3
Help Writing a SUM Formula 5
SUMPRODUCT help 5
Is that possible. More than on If Formula 2
value changes after hitting Tab or Enter button 2
Vlookup / Hlookup iterations 2
Index of Max Cell 7

Back
Top