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. I need a formula to create this.

Nick Korna

Hi @Nishu ,

If you want "Test" returned only for numbers, then this formula should work for you in Column B:

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

Hope this helps!