ExcelBanter - Using less than "<" in formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Using less than "<" in formula (https://www.excelbanter.com/excel-worksheet-functions/200298-re-using-less-than-formula.html)

Bob Umlas, Excel MVP

Using less than "<" in formula

=if(ust!i9="m9",
if(rawdata!r2<datevalue("05 may 08"),ust!$b12," ")

"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.

All times are GMT +1. The time now is 04:08 AM.