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

%3CLINGO-SUB%20id%3D%22lingo-sub-1843275%22%20slang%3D%22en-US%22%3EHow%20to%20add%20text%20in%20a%20cell%20which%20is%20part%20of%20a%20formula%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1843275%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20simple%20formula%20in%20my%20workbook%20%2F%20spreadsheet.%20I%20enter%20a%20value%20in%20column%20A%20and%20multiply%20that%20with%20another%20to%20get%20the%20final%20result.%20example%3A%20assuming%20the%20formula%20is%20%3DColumn%20A*0.68%20and%20if%20column%20A%20contains%20the%20number%2010%20then%20I%20will%20get%20a%20result%20of%206.8.%20What%20I%20am%20trying%20to%20do%20is%20or%20what%20I%20need%20help%20with%20is%20to%20enter%20text%20%22no%20data%22%20when%20there%20is%20no%20data%20available%20and%20have%20the%20formula%20show%20me%20a%20result%20of%20%220%22%20(zero).%20Can%20we%20do%20this%3F%20how%20should%20I%20alter%20my%20formula%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1843275%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1843487%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20add%20text%20in%20a%20cell%20which%20is%20part%20of%20a%20formula%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1843487%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F853887%22%20target%3D%22_blank%22%3E%40PrankyPrakash%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPerhaps%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DIF(ISTEXT(A1)%2C0%2CA1*0.68)%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1855381%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20add%20text%20in%20a%20cell%20which%20is%20part%20of%20a%20formula%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1855381%22%20slang%3D%22en-US%22%3EHi%20Sergei%2C%20thank%20you%20so%20much%20for%20your%20help.%20I%20have%20a%20query%20though.%20Since%20I%20have%20more%20than%20one%20column%20to%20check%20for%20text%2C%20it%20gives%20me%20an%20error%20-%20%22too%20many%20arguments%22.%20I%20have%20to%20check%20text%20in%20about%205%20columns%2C%20is%20there%20a%20way%20to%20do%20that%20or%20is%20it%20limited%20to%20a%20max%20of%20two%20columns%3F%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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

@PrankyPrakash 

Perhaps

=IF(ISTEXT(A1),0,A1*0.68)
Highlighted
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

@PrankyPrakash 

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.