Highlighted
New Contributor

# How to add text in a cell which is part of a formula?

I have a simple formula in my workbook / spreadsheet. I enter a value in column A and multiply that with another to get the final result. example: assuming the formula is =Column A*0.68 and if column A contains the number 10 then I will get a result of 6.8. What I am trying to do is or what I need help with is to enter text "no data" when there is no data available and have the formula show me a result of "0" (zero). Can we do this? how should I alter my formula?

3 Replies
Highlighted

# Re: How to add text in a cell which is part of a formula?

Perhaps

``=IF(ISTEXT(A1),0,A1*0.68)``
Highlighted

# Re: How to add text in a cell which is part of a formula?

Hi Sergei, thank you so much for your help. I have a query though. Since I have more than one column to check for text, it gives me an error - "too many arguments". I have to check text in about 5 columns, is there a way to do that or is it limited to a max of two columns?
Highlighted

# Re: How to add text in a cell which is part of a formula?

You check within the formula you applied. Let assume all values are numbers and you only multiply on 0.68, what will be your formula - cell by cell =A1*0.67; =A2*0.68; etc or something like =A1:F99*0.68 or what?

Perhaps you may generate small sample file to illustrate an issue.