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

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

greatest value function?
 

=300 / MAX(E3:E5)
--
Gary''s Student - gsnu200802