Hello,
I have this spreadsheet with columns, say A,B , Date and Grade. On the last column, I have a date entered.
I do some desicion making, and enter my decision on the grade column based on a comparisson, of all the columns and the difference bettween the system date, and the date column eg
If A>2 and B>5 and date >3 Then
grade="Good"
Else If A>2 and B>5 and Date<3 Then
Grade="Bad"
Else grade ="Unknown"
The " date <3" implies that the system date is say 26th Sept 2005 and the entry on the date column is say14th Aug 2004, then date <3 since the two dates are less than 3 yrs apart.
How do I code that logic?
Thanks
Bookmarks