Hello, can anyone help me please!!??
I have a cell named "% Compete" and columns named Week 1, Week 2, Week 3,
Week 4 and so on up to week 28
When the user types in week 1, 50% and then 60% in week 2 I need the cell "%
complete" to automatically update each time the user inputs the % complete.
Please help!!
James Snell - 14 Mar 2008 10:48 GMT
You're looking for the formula =max(cellrange)
That will return the highest value entered in the range of cells.
> Hello, can anyone help me please!!??
>
[quoted text clipped - 5 lines]
>
> Please help!!
Neil Holden - 14 Mar 2008 12:37 GMT
Thankyou very much. Much appreciated.
> You're looking for the formula =max(cellrange)
>
[quoted text clipped - 9 lines]
> >
> > Please help!!