Home » Forums » Open Source Learning Center » Question and Answer

formula help please

Consigliere's picture
Submitted by Consigliere on 11 September, 2015 - 22:31

Hello
I would like help with a formula to find max value in a column and display that value
in all rows of a new column.
please see attached
Many Thanks
Ian

AttachmentSize
MaxValueFormula.xlsx8.88 KB
‹ Automatic calculation of minimum or maximum value in a cell Excel Forum Help Please ›
»

in C2 enter the

Submitted by mec1981 on 22 September, 2015 - 07:01.

in C2 enter the following:

=if(A2=1,8,9)

Copy down

Regards
Mark

»
Consigliere's picture

Thanks Mec, however that

Submitted by Consigliere on 22 September, 2015 - 09:34.

Thanks Mec, however that wasn't quite what I was after but anyway I have sorted it out.
Many thanks for responding
Ian

»