How do I write a formula that will return a number or a blank cell if there is any text in the previous cell?

Question

For example if there is an item description in cell A5, I want cell A6 to put in the number 395. If there isn't any text at all in A5 I want cell A6 to be blank. Cell A5 will never have numbers in it.

Answer 1

In cell A6

=if(A5="",,395)

Note, this will make ANY description cause 395 to appear in A6.

You then copy this down the column to the cells you want to happen.

Answer 2

=IF(ISTEXT(A5),195,"")     istext checks for text and returns true or false.    if checks value of istext   if true enters 195, if false enters blank

Answer 3

You should use the IS... functions to check cell contents.

=IF(ISBLANK(A5),,395)