Questions & Answers for: excel formulars

Excel Spreadsheet - suppressing zeros Please tell me how to get rid of all the zeros at the end of a formular result in the same column e.g. 1.98745432872000000000000 & 0.4500000000 but still keeping ...

...B5, then 30 in cell C4, and 30 in cell C5.....the result in cell A3 is 110. Hope this helps. in excel, if you do something like     = B2 + C2 & "  + a2 "   then ...

Excel fromula Hi, I have an excel sheet with a formula for summing columns: =SUMIF(B2:B23,4,C2:C23). This is for my trial 21. My next trial is 33; the following will be 37 and so on. The numbers do ...

I checked the cell that the warning points me to, and the formular is correct, how do I remove the circular warning? what is the formula?

is it possible to modify a cell content without deleting everything in ms excel? Hi There. Yes - it is possible to modify the content of a cell without deleting everything. Place your curser in the ...