Welcome guest. Before posting on our computer help forum, you must register. Click here it's easy and free.

Author Topic: excel formula question  (Read 2060 times)

0 Members and 1 Guest are viewing this topic.

JAgosta

    Topic Starter


    Starter

    • Experience: Beginner
    • OS: Unknown
    excel formula question
    « on: August 08, 2012, 05:05:41 AM »
    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

    soybean



      Genius
    • The first soybean ever to learn the computer.
    • Thanked: 469
    • Computer: Specs
    • Experience: Experienced
    • OS: Windows 10
    Re: excel formula question
    « Reply #1 on: August 09, 2012, 07:57:06 AM »
    By "not equal spaces", do you mean the cell is not empty?