| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
EXCEL Statement help
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!! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
EXCEL Statement help
You're looking for the formula =max(cellrange)
That will return the highest value entered in the range of cells. "Neil Holden" wrote: 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!! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
EXCEL Statement help
Thankyou very much. Much appreciated.
"James Snell" wrote: You're looking for the formula =max(cellrange) That will return the highest value entered in the range of cells. "Neil Holden" wrote: 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!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF statement inside a SUMIF statement.... or alternative method | Excel Worksheet Functions | |||
| Reconcile Bank statement & Credit card statement & accounting data | Excel Worksheet Functions | |||
| Embedding an OR statement in an IF statement efficiently | Excel Discussion (Misc queries) | |||
| Excel VBA OR statement | Excel Programming | |||
| appending and IF statement to an existing IF statement | Excel Worksheet Functions | |||
Linear Mode
