If then issue on table

[rfletcher35]

I have the following figures below

Namex2 Namex3 Namex4 Column3

21.25
21.5	29.5		29.5
6.25
14.5
31.75
12.5
16.5
11.75
10.75		27.25
35.75
8.75

<tbody>
</tbody>

I have the following code in column 3 on the row where it has 29.5

=IF([@[NAME x3]=]=>0,[@[NAME x3]],IF([@[NAME x4]=]=>0,[@[NAME x4]],[@NAMEx2]))


Basically I'm wanting it to look at the 3 columns if name 3 or 4 has something in then put that figure, if not put the figure in under name 2

Why isn't working it looks correct?


Fletch

 

[Chihiro]

Try...

=IF([@[NAME x3]=]=>=0,[B][@[NAME x3]],IF([@[NAME x4]=]=>=0,[@[NAME x4]],[@NAMEx2]))[/B]

If there is space between "NAME" & "x2" then change to [@[NAME x2]]

EDIT: Hmm for some reason, the forum is adding "=" signs before and after second "]" remove that.

 

[rfletcher35]

I tried that and it produced the same result as what I got. There should always be a figure in the cell.

 

[rfletcher35]

I tried that and it produced the same result as what I got. There should always be a figure in the cell.

There has to be a simple way of running down a column saying if there is a value in 1 and ignore the others

 

[Chihiro]

Hmm, check if Blank cells are truely blank or if it contains some invisible character and/or space.

 

[rfletcher35]

They are blank apart from formulas.
I've even copied the 3 columns outside the table and just pasted the values so there are no formulas but it still does not work.

 

[Chihiro]

I've not had any issue producing result. Sorry to say, without looking at your actual workbook. I don't think I can help you further.

 

[rfletcher35]

I figured the formula, I used the following

=IF(AND(T2="",U2=""),S2,IF(OR(T2>"",U2=""),T2,IF(OR(U2>"",T2=""),U2,"")))