Forum Discussion

Chefshop's avatar
Chefshop
Copper Contributor
Feb 05, 2019

Struggling with writing this IF formula correctly

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!!

 

 

 

 

Formulas and Functions
  • SergeiBaklan's avatar
    SergeiBaklan
    MVP
    Feb 07, 2019

    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.

Resources