Home

Struggling with writing this IF formula correctly

Chefshop
Occasional Visitor

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.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies