Need a formula to flag a cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a vehicle maintenance worksheet with a row for each vehicle. In one
cell I have the mileage, in another I have a cell with a text box that has
the mileage of last oil change. Is there a formula to flag a cell if the
current mileage is 3000 more than the number in the text box?
 
Try this

=IF(C4-B4>3000,"<<< Warning - Veh has exceeded Oil Change by
&C4-B4-3000& " miles. Please arrange service !!",""
 
I assumed you meant cell ref not a text box.

I also assumed cell C4 had current mileage and B4 has mileage of las
oil change. In cell D4 copy the foumla in.

Change cell reference as required
 
Back
Top