EXCEL Statement help

  • Thread starter Thread starter Neil Holden
  • Start date Start date
N

Neil Holden

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!!
 
You're looking for the formula =max(cellrange)

That will return the highest value entered in the range of cells.
 
Thankyou very much. Much appreciated.

James Snell said:
You're looking for the formula =max(cellrange)

That will return the highest value entered in the range of cells.
Click to expand...
 
You must log in or register to reply here.

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

Streamlining repetitive report 9
Excel Forms Spin Button - Return to 1 after max value 0
Spam 4
need help writing a script Hiding a range when a cell with in is greater than 53.. 1
multiple "IF" statements in function 7
Dropdown menu 3
Excel Limit to Named Ranges 1
Search & insert 3

Back
Top