| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
greatest value function?
if i have a column of values, for example column E3=4, E4=5, E5=6, etc., is
there a way that i can select the largest value in column E (6 in this case) to use in the formula in another cell (e.g. cell P8) in which i want to calculate a value using the highest value in column E (e.g. =300/E5 which is 300/6). Then, if the value of 8 is entered in cell E6, the value in cell P8 is calculated as 300/E6 or 300/8 because now 8 is the greatest value in column E. is there a way to do this? Thanks. EG |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
greatest value function?
Try
=300/MAX(E3:E100) Mike "EG" wrote: if i have a column of values, for example column E3=4, E4=5, E5=6, etc., is there a way that i can select the largest value in column E (6 in this case) to use in the formula in another cell (e.g. cell P8) in which i want to calculate a value using the highest value in column E (e.g. =300/E5 which is 300/6). Then, if the value of 8 is entered in cell E6, the value in cell P8 is calculated as 300/E6 or 300/8 because now 8 is the greatest value in column E. is there a way to do this? Thanks. EG |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
greatest value function?
=300 / MAX(E3:E5)
-- Gary''s Student - gsnu200802 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Function to show the greatest number of characters | Excel Worksheet Functions | |||
| Finding the greatest value | Excel Discussion (Misc queries) | |||
| Greatest to smallest | Excel Discussion (Misc queries) | |||
| Displaying Greatest to Least? | Excel Discussion (Misc queries) | |||
| How to filter by greatest of | Excel Worksheet Functions | |||
Linear Mode
