how do you ignore blank cells in formulas
 

I am trying to write a formula that results in the earliest date using min
except that a blank cell on any page results in a 0.
=MIN('1Jan-9Jan'!R196,'10Jan-16Jan'!R196,'17Jan-23Jan'!R196)
What do I need to do to ignore the blank cells

Kerry,

I opened a new workbook and created 4 sheets. In cell B2 of the first 3
shhets a put in some numbers and on the fourth sheet set up:

=MIN(Sheet4!B2,Sheet3!B2,Sheet2!B2)

and this works when one of the data sheets has a blank cell or a space
but not when the cell has a zero in it.

Can you confirm that your target cells are really empty?


--
HiArt
------------------------------------------------------------------------
HiArt's Profile: http://www.excelforum.com/member.php...o&userid=19953
View this thread: http://www.excelforum.com/showthread...hreadid=345825

see ans in your 6 minutes later post

--
Don Guillett
SalesAid Software

"Kerry" wrote in message
...
I am trying to write a formula that results in the earliest date using min
except that a blank cell on any page results in a 0.
=MIN('1Jan-9Jan'!R196,'10Jan-16Jan'!R196,'17Jan-23Jan'!R196)
What do I need to do to ignore the blank cells