I need a formula to return a value in column B, if column A has some random number.

Nishu

In the below example: Column A has some random numbers and i need a value "Test" to be displayed, if column A has a number, otherwise it should be blank incase if there is no value in Column A.

Sameer Karkhanis

Use this in Column B

=IF(ISNUMBER([Column A]@row), "Test", "")