Need formual for Highest Cell

**tirthasarathi** · 10-04-2010, 07:03 AM

Sir

If

A1=9, B1=10, C1= 30, D1= 99

E1(highest vlaue) = 99

Please provide me a formula for that

Thanks

Tirtha Sarathi

**Domski** · 10-04-2010, 07:05 AM

Have a look at the Max function e.g. =MAX(A1:D1)

Dom

**tirthasarathi** · 10-04-2010, 07:13 AM

Sir

Sheet 1 contains following :

A1=9, B1=10, C1= 30, D1= 99

Sheet 2 Contains following :

A1=15, B1=18, C1= 36, D1= 89

E1(highest vlaue) = 99

Please provide me a formula for that

Thanks for your prompt reply.

Tirtha

**Cutter** · 10-04-2010, 07:24 AM

=MAX(Sheet1:Sheet2!A1:D1)

**Domski** · 10-04-2010, 07:26 AM

=MAX(Sheet1!A1:D1,Sheet2!A1:D1)

Dom

**Domski** · 10-04-2010, 07:33 AM

Originally Posted by Cutter

=MAX(Sheet1:Sheet2!A1:D1)

It's worth pointing out that using this construction if you have any sheets on your worksheet tabs between sheets 1 and 2 they will be included in the results of the formula.

Dom