Transporter
New Member
- Joined
- Mar 5, 2009
- Messages
- 3
I'm in charge of the transportation department for a community clinic, and am creating a workbook that tracks the mileage on the vans we use. I want to include a formula that will alert me when a van has passed a certain mileage.
The only formula I am aware of is "=IF(A1=mileage, "x". "")"
The problem is that I want it to apply to this setup:
-Date- -Start- -End-
1/1/09 44,000 44,100
.
.
.
1/31/09
As I understand it, I need a formula that uses a matrix in order to track the "Start" and "End" miles for all 31 days.
Any ideas?
The only formula I am aware of is "=IF(A1=mileage, "x". "")"
The problem is that I want it to apply to this setup:
-Date- -Start- -End-
1/1/09 44,000 44,100
.
.
.
1/31/09
As I understand it, I need a formula that uses a matrix in order to track the "Start" and "End" miles for all 31 days.
Any ideas?