Hey guys, anyone any good with excel here? im trying to make a simple Laptop Loans sheet for work. i have cell which shows the current date and i have a row of Due dates, what i need to do is work out to do do a new row which would show free if nothing is entered on the due date, on loan if a date is entered and overdue in Red if the date is entered and is in the past? anyone can help?
Excel help
- Thread starter territt
- Start date
Soldato
- Joined
- 19 Dec 2006
- Posts
- 9,262
- Location
- Saudi Arabia né Donegal
What you need to do is use the =if function in order to determine which value you want displayed.
For example, =if(len(a1)>0,if(A1>today()),"overdue","leased out",),"Available").
The first If statement checks to see if there is anything entered into the due date field, in this case A1.
The second if statement is nested within the true condition of the first if statement and checks whether the laptop is overdue or not.
The red/black text can be sorted out using conditional formating.
For example, =if(len(a1)>0,if(A1>today()),"overdue","leased out",),"Available").
The first If statement checks to see if there is anything entered into the due date field, in this case A1.
The second if statement is nested within the true condition of the first if statement and checks whether the laptop is overdue or not.
The red/black text can be sorted out using conditional formating.