If statement

[Anonymous]

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)

[sunny_talwar]

May be you need or between the two conditions?

=if(Size='40 <44' or Size='40 < 44', Size)

[Anonymous]

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.

[sunny_talwar · Accepted solution]

Oh okay... try this

=if(Size = '40 <44', '40 < 44', Size)

[Anonymous]

That worked. Thank you!