Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formula
Hi,
Can you help me here? - I would like to create a formula that automatically enters either the word "expired" or the word "current" into a column, when it looks up the date in another column. I would like this column to automatically tell me whether that row is current or expired, based on the other column's date. If the date in the column is passed then my new column should say "expired", and if it is in the future then my new column should say "current". I hope this is clear. Thankyou Kate |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF formula? | Excel Worksheet Functions | |||
writing a formula for a colored value | New Users to Excel | |||
referencing named formula using INDIRECT function | Excel Worksheet Functions | |||
Simplify formula | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |