Quote:

Weird question... How come this formula works in Excel 2010 but doesn't work in Excel 2003 (It has a compatibility pack)? =((IF('Rig Mat Pricing'!E15=2,IF('Rig Mat Pricing'!E14<20,5.8,IF('Rig Mat Pricing'!E14<24,6.4,IF('Rig Mat Pricing'!E14<33,6.7,IF('Rig Mat Pricing'!E14<40,6.9,IF('Rig Mat Pricing'!E14<46,7.3,IF('Rig Mat Pricing'!E14>45,11.3,0)))))),IF('Rig Mat Pricing'!E15=3,IF('Rig Mat Pricing'!E14<20,6.88,IF('Rig Mat Pricing'!E14<24,7.4,IF('Rig Mat Pricing'!E14<33,8,IF('Rig Mat Pricing'!E14<40,8.6,IF('Rig Mat Pricing'!E14<46,9.3,IF('Rig Mat Pricing'!E14>45,12.4,0)))))),IF('Rig Mat Pricing'!E15=4,IF('Rig Mat Pricing'!E14<20,8,IF('Rig Mat Pricing'!E14<24,8.6,IF('Rig Mat Pricing'!E14<33,9.3,IF('Rig Mat Pricing'!E14<40,11.1,IF('Rig Mat Pricing'!E14<46,11.8,IF('Rig Mat Pricing'!E14>45,13.6,0)))))),0)))+IF('Rig Mat Pricing'!E17="yes",1.9))+(IF('Rig Mat Pricing'!E13>8,'Rig Mat Pricing'!E13*0.25,IF('Rig Mat Pricing'!E13<8,'Rig Mat Pricing'!E13*-0.1,0))))