Auto Glass: ADAS Calibration Add-On

All versions

Modern windshields carry the camera that runs lane-keep and auto-braking, so most replacements now need a calibration afterward — but not all of them. One IF adds the calibration fee to the cars that need it and leaves the rest alone.

Quick formula: Add the fee only when calibration is required:

=IF(C2="Yes",B2+D2,B2)

A $320 windshield that needs calibration bills at $470; one that does not stays at $320.

Functions used (tap for the full reference guide):

The example

Three replacements. The calibration column is a simple Yes or No per vehicle.

	A	B	C	D	E
1	Vehicle	Glass	Calibrate?	Cal fee	Total
2	Camry	320	Yes	150	$470
3	Civic	280	No	150	$280
4	F-150	410	Yes	199	$609

The formula

IF checks the calibration column and picks one of two prices:

=IF(C2="Yes",B2+D2,B2) // needs calibration -> glass + fee, otherwise glass alone

How it works

Three parts inside the parentheses:

C2="Yes" is the test — does this vehicle need calibration?
B2+D2 is the value when the test is true: glass price plus the calibration fee.
B2 is the value when it is false: the glass price on its own.
Keeping the fee in its own column lets a static and a dynamic calibration carry different prices without touching the formula.

If you offer both static and dynamic calibration, swap the Yes/No column for a type and reach for a lookup — but for a single calibration price, IF is all you need.

Try it: interactive demo

Interactive

Set the glass price, whether calibration is needed, and the calibration fee.

Glass price ($)

Calibration needed

Calibration fee ($)

Variations

Two calibration types

Look the fee up by type when static and dynamic are priced differently.

=B2+IFERROR(VLOOKUP(C2,$G$2:$H$4,2,0),0)

Flag cars that skipped calibration

An auditing check so a required calibration is never left off the ticket.

=IF(AND(C2="Yes",D2=0),"Missing fee","OK")

Pitfalls & errors

Match the text exactly. C2="Yes" will not catch "yes" with a lowercase y in some setups — use a dropdown so the column can only ever hold Yes or No.

Calibration is a safety item, not an upsell. If a vehicle's camera requires it, bill it every time; the IF makes that automatic rather than a judgment call.

Practice workbook

📊

Download the free Auto Glass: ADAS Calibration Add-On practice workbook

Edit the yellow glass, Yes/No, and fee cells; the total recalculates.

Frequently asked questions

Do all new windshields need calibration?

Most vehicles with camera-based driver assistance do, which is the majority of models from the last several years. The Yes/No column keeps the older cars from being charged for something they do not need.

Static or dynamic calibration?

That depends on the make and the equipment in your bay. If you bill them differently, use the two-type lookup variation; if you charge one flat calibration fee, the simple IF is enough.

Stop fighting formulas. Learn them in a day.

This recipe is one of hundreds of real-world formulas we teach. Our Excel Formulas & Functions class covers lookups, logic, text, and dynamic arrays hands-on — live in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.

See the Formulas & Functions Class

Function references: IF