Spreadsheet Help

[wiggyuk]

Hi all I was wondering if someone could give me some help with a spreadsheet, see below.

What I want is a formula that puts a L or something like that in the late colum so I can just filter by the late ones or the ones on time ?
At the moment I am trawling through each one and putting a 0 for ontime and a 1 for late.

 

[swinnie]

Use an IF Statement.
I have used date_required as A1, and date_dispatched as B1.

=IF(A1=B1,"Ontime","Late")

So values as follows:

=IF(A1=B1,"TRUE","FALSE")

Just change the A1 and B1 values to the respective cells. Hope this helps.

 

[Andy100]

As Swinnie says, although I'd probably use a greater than > and reverse the columns, provided you can despatch stuff both early and late.


So =IF(B1>A1,"Late","Ontime")

 

[wiggyuk]

Cheers lads, much apreciated.