I am moderately familiar with excel functions, but I am trying to create a variable formula. Our product has a certain amount of minimal cost which reflected in our smallest unit. as the product gets bigger the marginal costs go down. that is to say the first 30 sq ft or 4320 sq inches cost out at $.208333 per sq inch. larger sizes cost $.16 per sq inch.
We also have an option that adds $40.00, so I have that as the (AC32*40).
I have been trying =IF((AE32*AG32)>4320,(AE32*AG32)*0.16)+209+(AC32*40)
=IF((AE32*AG32)>4321,(AE32*AG32)*0.20833)+209+(AC32*40)
and this =SUM((AE22*AG22)*0.20833)+(AC22*40)
all of them work. but I need to be able to say, if((AE32*AG32)>4321,(AE32*AG32)*0.20833)+209+(AC32*40),((AE32*AG32)>4320,(AE32*AG32)*0.16)+209+(AC32*40)
when I add the two formulas I get errors. any idea why?
Bookmarks