Using less than "<" in formula
 

I'm trying to use a formula in one worksheet that draws data from two other
worksheet. I have no problem using the "" in formulas, but when I use the
"<" it won't work. My formula is =if(ust!i9="m9",
if(rawdata!r2"<05may08",ust!$b12," ")

It has issues with the date. I tried using AND in the formula but it
error'd on the date.

Any help would be greatly appreciated.

Using less than "<" in formula
 

Take the < symbol out of the quotes. And "05may08" is not a date. Put the
date in a cell and reference the cell. HTH Otto
"Bernie R" <Bernie wrote in message
...
I'm trying to use a formula in one worksheet that draws data from two
other
worksheet. I have no problem using the "" in formulas, but when I use
the
"<" it won't work. My formula is =if(ust!i9="m9",
if(rawdata!r2"<05may08",ust!$b12," ")

It has issues with the date. I tried using AND in the formula but it
error'd on the date.

Any help would be greatly appreciated.

Using less than "<" in formula
 

DATEVALUE("05MAY08") will convert that text to a valid excel date

"Otto Moehrbach" wrote:

Take the < symbol out of the quotes. And "05may08" is not a date. Put the
date in a cell and reference the cell. HTH Otto
"Bernie R" <Bernie wrote in message
...
I'm trying to use a formula in one worksheet that draws data from two
other
worksheet. I have no problem using the "" in formulas, but when I use
the
"<" it won't work. My formula is =if(ust!i9="m9",
if(rawdata!r2"<05may08",ust!$b12," ")

It has issues with the date. I tried using AND in the formula but it
error'd on the date.

Any help would be greatly appreciated.

Using less than "<" in formula
 

I would use an unambiguous date format:

=if(ust!i9="m9",if(rawdata!r2<date(2008,5,5),ust!$ b12,"")

And I'd return an empty string "" instead of " ".







Bernie R wrote:

I'm trying to use a formula in one worksheet that draws data from two other
worksheet. I have no problem using the "" in formulas, but when I use the
"<" it won't work. My formula is =if(ust!i9="m9",
if(rawdata!r2"<05may08",ust!$b12," ")

It has issues with the date. I tried using AND in the formula but it
error'd on the date.

Any help would be greatly appreciated.

--

Dave Peterson