Thanks guys, I just needed if it is blank or zero.

"Dav" wrote:


if all you want is the maximum value of b9:b120

=if(max(b9:b12)0,"PBR","PBO")

Regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=561378