|
Answer» 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 ABy "not equal spaces", do you mean the cell is not empty?
|
