Forum Discussion
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 ...
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.
