I have a formula in cell J9 as follows that i have conditional formatted to only show if cell H9 contains a figure.
What i need is for cell J9 to include the following code if cell I9 contains a figure instead of cell H9.
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?
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?