IF Formula - Help!
Thanks Ron, thats great - works perfectly!
"Ron Rosenfeld" wrote:
On Thu, 29 Mar 2007 04:04:00 -0700, hjm wrote:
I am trying to write a formula to show the 'soonest' date out of 2 columns,
but if both the columns are blank then show blank.
So far I have:
=IF(AA3AB3, AA3, AB3)
Which correctly shows the date, but where there is blanks it is dragging
through a date of 00/01/1900.
Can anyone help me extend my formula?
Many Thanks
Helen
=IF(MIN(A10,B10)=0,"",MIN(A10,B10))
--ron
|