Thread: Calculating with some rules
View Single Post
  #2  
Old 01-09-2009, 05:51 PM
martindwilson's Avatar
martindwilson martindwilson is offline
Forum Guru
  
Join Date: 23 Jun 2007
Location: London,England
MS Office Version:office 97 ,2003 ,2007
Posts: 6,088
martindwilson Has a higher level of understanding martindwilson Has a higher level of understanding martindwilson Has a higher level of understanding martindwilson Has a higher level of understanding martindwilson Has a higher level of understanding martindwilson Has a higher level of understanding martindwilson Has a higher level of understanding
size in a1 cost per m2 in b1

Code:
=if(and(a1>0,a1<=0.42),0.42*b1,if(and(a1>0.42,a1<=3.2),a1*b1,if(and(a1<=4.2,a1>3.2),(a1*b1)+(a1*b1)*35%,if(a1>4.2,(a1*b1)+(a1*b1)*45%,""))))
Reply With Quote