Return highest number or a blank if 0

[Toney]

Hi all

I have three cells D2, E2 and F2 that may or may not have a number. I'd like
to have the highest number from these cells returned to C2. If D2, E2 and F2
are blank, I'd like a blank in C2.

Using MAX(D2:F2) returns a zero to C2 if these cells are empty.

Thanks in advance for any help

Toney

 

[John C]

=IF(MAX(D2:F2)=0,"",MAX(D2:F2))

 

[Dave Peterson]

=if(count(d2:f2)=0,"",max(d2:f2))

Hi all

I have three cells D2, E2 and F2 that may or may not have a number. I'd like
to have the highest number from these cells returned to C2. If D2, E2 and F2
are blank, I'd like a blank in C2.

Using MAX(D2:F2) returns a zero to C2 if these cells are empty.

Thanks in advance for any help

Toney

 

[T. Valko]

Try this:

=IF(COUNT(D2:F2),MAX(D2:F2),"")

 

[Toney]

John, Dave and T,

Thanks for the quick reply. All the suggested formulas appear to work
perfectly.

Thanks again

Toney

 

[Don Guillett]

Another using an array formula that must be entered using ctrl+shift+enter
=MAX(IF(D2:f2>0,D2:f2))

 

[David Biddulph]

Yes, but remember that some of the formulae suggested will ignore an entered
value of zero, and others won't. Decide which you want.