This page illustrates multiple ways to count cells with text in Excel. Visit our page about the COUNTIF function to count cells that contain specific text.
The MsgBox is a dialog box in Excel VBA you can use to inform the users of your program.
To delete blank rows in Excel use Go To Special Blanks. You can also use the COUNTA function and a filter to remove empty rows.
1 kg = 2.20462 lbs (pounds) and 1 lb (pound) = 0.45359 kg. Use a simple formula the CONVERT function or download our free unit converter to convert from kg to lbs or vice versa.
There's no SUBSTRING function in Excel. Use MID LEFT RIGHT FIND LEN SUBSTITUTE REPT TRIM and MAX in Excel to extract substrings.
Color Scales in Excel make it very easy to visualize values in a range of cells. The shade of the color represents the value in the cell.
Quickly format a range of cells by choosing a table style. You can also create your own table style in Excel. Quickly format a cell by choosing a cell style.
To add a column in Excel right-click the column letter and click Insert. When you insert a column or row cell references update automatically.
Use MROUND in Excel to round a time to the nearest 15 minutes the nearest 30 minutes the nearest hour etc.
A quadratic equation is of the form ax2 + bx + c = 0 where a ≠0. A quadratic equation can be solved by using the quadratic formula. You can also use Excel's Goal Seek feature to solve a quadratic equation.
Excel meets AI – Boost your productivity like never before!
At Formulas HQ, we’ve harnessed the brilliance of AI to turbocharge your Spreadsheet mastery. Say goodbye to the days of grappling with complex formulas, VBA code, and scripts. We’re here to make your work smarter, not harder.
Categories
113
49
16
Ready to Get Started?
Improve your proficiency in spreadsheets, increase your productivity and eliminate the challenges associated with intricate calculations and formulas for good.
