Currently in Monday formulas there is no formulas such as: AverageIF or DivideIF or MultiplyIF, so that you can avoid using null or 0 in your number based equations. This is important when using columns like “rating” and without said variables it is almost impossible to extrapolate useful information from multiple number or rating based columns.
Related topics
| Topic | Replies | Views | Activity | |
|---|---|---|---|---|
| Need help creating AVERAGEIF style function for a survey using rating columns | 2 | 1341 | March 27, 2023 | |
| Forms: Setting up proper formula for "When non-mandatory fields are empty, exclude from average calculation" | 3 | 572 | January 29, 2024 | |
| Divide by 0 error in formula column | 6 | 4511 | March 30, 2021 | |
| Formular that can handle null values in multiple cell | 4 | 645 | October 20, 2023 | |
| Blank cells generates errors in FORMULAS | 3 | 1161 | August 4, 2023 |