Nov 01 2020 07:52 PM
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?
Nov 01 2020 11:22 PM
Nov 04 2020 04:08 PM
Nov 05 2020 12:51 AM
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.