# If formula help

#### John T

##### Board Regular
I have a formula in cell J9 as follows that i have conditional formatted to only show if cell H9 contains a figure.
Code:
``=\$A\$44&TEXT(\$B\$44,"ddmm")``

What i need is for cell J9 to include the following code if cell I9 contains a figure instead of cell H9.

Code:
``=\$A\$45&TEXT(\$B\$44,"ddmm")``

So the outcome is dependant on if cell H9 or I9 contains a figure.

Is there also a way if both H9 & I9 contain a figure to display a furthur outcome?

### Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).

Replies
0
Views
97
Replies
4
Views
352
Replies
2
Views
262
Replies
3
Views
106
Replies
0
Views
244

1,195,666
Messages
6,011,043
Members
441,580
Latest member
BornholmerBjarne

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