The number on the film roll is not what ends up on the window. Factory glass already blocks some light, and tint multiplies against it. Multiply the two percentages to get the net VLT — the figure a meter (and a police officer) will read.
A 35% film on 78% factory glass nets 27.3%, not 35% — the difference is what keeps a job legal.
The example
Three vehicles, each with a chosen film VLT and the factory glass VLT it is going over.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Vehicle | Film VLT | Glass VLT | Net VLT |
| 2 | Storefront | 35 | 78 | 27.3 |
| 3 | Sedan | 20 | 88 | 17.6 |
| 4 | SUV | 50 | 80 | 40.0 |
The formula
Two transmittances multiply; dividing by 100 keeps the answer a percent:
How it works
Transmittances stack by multiplication, not subtraction:
B2*C2multiplies the two percentages — 35 x 78 = 2730./100brings it back to a percent because both inputs were already percentages.ROUND(...,1)gives a clean net VLT to compare against the local legal limit.- Never add or subtract the two numbers — light that passes the film then has to pass the glass, which is a product, not a sum.
Check the net number, not the film number, against your state's window-tint law before you cut.
Try it: interactive demo
Enter the film's VLT and the factory glass VLT.
Variations
Two films stacked
Security film under a tint? Multiply all three transmittances.
Legal check
Flag whether the net VLT clears a 25% limit.
Pitfalls & errors
Do not subtract the percentages. 35% film on 78% glass is 27.3% net, not 13% (35 minus 22). Subtraction will make you promise a legal job that fails a meter.
Ask for the factory glass VLT, not the assumption that it is clear. Privacy glass on rear windows is already deeply tinted, so even a light film can put the net well below the limit.
Practice workbook
Frequently asked questions
Why multiply instead of subtract?
Does the legal limit apply to the film or the net?
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