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...
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.