Originally Posted by slvoid
=ROUND(IF(LIGHTTYPE="Halogen",(-0.0002*WATTAGE^4 + 0.0143*WATTAGE^3 - 0.4048*WATTAGE^2 + 5.5274*WATTAGE - 9.2313)-2,IF(LIGHTTYPE="HID",(-0.0002*WATTAGE^4 + 0.0143*WATTAGE^3 - 0.4048*WATTAGE^2 + 5.5274*WATTAGE - 9.2313)*1.75,(-0.0002*((WATTAGE+4)*1.1)^4+0.0143*((WATTAGE+4)*1.1)^3-0.4048*((WATTAGE+4)*1.1)^2+5.5274*((WATTAGE+4)*1.1)-9.2313))),1)
That is the best use of Excel ever! Thanks!