In article ,
Chris wrote:

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?


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

--
Domenic
http://www.xl-central.com