Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
My if statement is returning 0 in the size field for the '40 <44' amount instead of '40 < 44'. What am I doing wrong?
=if(Size='40 <44', Size='40 < 44',Size)
May be you need or between the two conditions?
=if(Size='40 <44' or Size='40 < 44', Size)
It's only one condition. I've got some Excel sheets with 40 <44 and others with 40 < 44. So if Size is equal to '40 <44', then I want it to equal '40 < 44', otherwise keep Size.
Oh okay... try this
=if(Size = '40 <44', '40 < 44', Size)
That worked. Thank you!