Esteemed listers:
I’m attempting to set a cell’s value as follows, I have columns b and c either one (and only one) will contain values. Once I determine which column has data, I need to interrogate it and set values as appropriate.
Pseudo code:
If b13 not equal spaces and b13 <= 10000 then set value to 32
else if b13 not equal spaces and b13 > 10000 then set value to 64
else c13 not equal spaces and c13 <= 10000 then set value to 32
else if c13 not equal spaces and c13 > 10000 then set value to 64
Tried various iterations such as (to no avail):
="SEGSIZE "&IF(AND((Request!B13)<>" ",(Request!B13)<=10000),32,64),IF(AND((Request!C13)<>" ",(Request!C13)<=10000),32,64)
Tku,
Jeff A
