View Single Post
  #1  
Old 01-09-2009, 05:06 PM
ronanalex ronanalex is offline
Registered User
 
Join Date: 09 Jan 2009
Location: dublin,ireland
MS Office Version:Excel 2003
Posts: 1
ronanalex is becoming part of the community
Calculating with some rules

Hi All. Perhaps someone might be able to assist.

I need to a formula which can calculate the cost of various types of glass subject to the following rules.
1. if area is below 0.4 m2 then the cost should not be less than 0.4m2 cost.
2. if area is above 3.2m2 cost should be plus 35%.
3. if area is above 4.2m2 cost should be plus 45%.


Best regards
Reply With Quote