You can use SUMIF in Google Sheets to add numbers together that are associated with a date range, specific text, or meet a numeric criterion. Here's everything you need to know to use the SUMIF ...

For example, the value in cell G4 (1.623) has been rounded up to 2 decimal places. Here, the rounding place is 2, which is digit 2, and the digit next to 2 is 3, which is less than 5.

To add a zero after a number in Excel, you can use the CONCATENATE function. For that, you need to choose a cell and enter this formula: =CONCATENATE(A1, “000”).

You can use the COUNTIF function in Google Sheets to find the number of items in a range that meet certain criteria. You can use text, numbers, and dates as criteria in the COUNTIF function.