Max formula, max values in range all less than 1

[jedwardo]

Hi, I'm trying to use max to find the largest entry in a range. Any possible entry will be in between 0 and 1. Is this not possible? It doesn't pick up on any values in said cells unless I enter a value greater than or equal to 1.

=MAX(BR2:BU2)

Formula is in BW2 but won't max the columns when values are less than 1

[/IMG]

 

[jedwardo]

also tried this

=IF(BU2 <>"", BU2, IF(BT2 <>"", BT2, IF(BS2 <>"", BS2, IF(BR2 <>"", BR2, ""))))

and the same thing except greater >0 instead of <> "" but got the same zero value result.

 

[mfexcel]

Did you check the format in BW2?

Hi, I'm trying to use max to find the largest entry in a range. Any possible entry will be in between 0 and 1. Is this not possible? It doesn't pick up on any values in said cells unless I enter a value greater than or equal to 1.

=MAX(BR2:BU2)

Formula is in BW2 but won't max the columns when values are less than 1

 

[jedwardo]

I don't believe I did. I'll check that out when I get home

 

[jedwardo]

Haha, that was it. Thanks mfexcel

 

[mfexcel]

You are welcome.

Haha, that was it. Thanks mfexcel