# If then issue on table

#### rfletcher35

##### Active Member
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

Last edited:

### Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a \$25,000 loan, 5% annual interest, 60 month loan.
Try...
Code:
``=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.

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

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

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

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.

Last edited:
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.

I figured the formula, I used the following

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

Replies
0
Views
554
Replies
12
Views
799
Replies
3
Views
188
Replies
1
Views
605
Replies
3
Views
1K

1,203,214
Messages
6,054,202
Members
444,708
Latest member
David R__

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back