Forum Discussion
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
- 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?
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.
