Value cell

[hsandeep]

L9 & R9 contains either "" (null) or values.
In S9, I want to get L9 or R9 whichever contains value.

 

[VoG]

Try

=IF(L9="",R9,L9)

 

[Peter_SSs]

.. contains value.

If those values are text then try

=L9&R9


If the values are numerical, try

=(L9&R9)+0

 

[hsandeep]

If the values are numerical, try

=(L9&R9)+0[/QUOTE]

L9 & R9 are formula generated cells. For "" (null) generated in L9 as well as R9, I got #VALUE! using this formula !!!

 

[Peter_SSs]

L9 & R9 are formula generated cells. For "" (null) generated in L9 as well as R9, I got #VALUE! using this formula !!!

I thought one of the cells contained a value. If the formula returns "" or a number but both cells can be blank then my formula is not suitable. In any case VoG's should work fine.

 

[hsandeep]

Yes VoG's works fine.