Struggling with writing this IF formula correctly

Copper Contributor

I am trying to write a formula that will take information from 2 columns, a unit size "small" & "large", and its corresponding weight "1" "2" etc. 

 

If the unit size is "small" and weight is less than or equal to 1 than 'x', if not 'y'

If the unit size is "large" and weight is less than or equal to 1 than 'p', if not 'q'

If the unit size is "large" and weight is greater than 1 but less than or equal to 2 than 'r', if not 's'

If the unit size is "large" and weight is greater than 2, that 'j', if not 'k'

 

I have them solved individually but I am unsure how to put them all together into one formula. This is what I have...

 

=(IF(AND(F2="Small",G2<=1),2.41,8.13))

=IF(AND(F3="Large",G3<=1),3.19,4.71)

=IF(AND(F4="Large",G4>1<=2),4.71,4.71+(0.38*(G4-2)))

 

Any help is appreciated sincerely!!

 

 

 

 

1 Reply

Hi,

 

As variant that could be nested IF like

=IF(F2="small",IF(G2<=1,"x","y"),IF(F2="large",IF(G2>2,"j",IF(G2>1,"r","q")),"no such size"))

(not tested).

 

However, you logic is conflicting. For example, for the large

weight is less than or equal to 1 than 'p', if not 'q'

That means for any weight greater than 1 it shall be "q"

 

At the same for the weight greater than 2, what is definitely greater than 1, it shall be "r" or "s". Not "q" as above.