Listing IF formulas

Hello RobbieD2020,

I would like to add just a few things to the wonderful help that you've received so far.

As mathetes and JKPieterse have pointed out, there are often more efficient and less messy ways to deal with situations like the one you have presented to us. When nesting a large number of functions together, it is very easy to miss something as simple as a single ",". And when you miss something this small, trying to fix it is like trying to find a needle in a haystack. In your nested functions, as SergeiBaklan pointed out, there is at least one missing [value_if_false]. This could be resolved with a simple ",".

You attempt to write a single logical condition as multiple conditions. For example, "IF($D22>=2,$D22<4,IF($C22=25...". The way that this is written, the IF() function reads "$D22>=2" as the logicial condition, "$D22<4" as the [value_if_true], and "IF($C22=25..." as the [value_if_false]. Instead, an appropriate way to express these multiple conditions is "IF(AND($D22>=2,$D22<4,$C22=25),...".

The use of the SUM() function in your function is not necessary. For example, "SUM($D22/(($BP22-56-245)*($BQ22-110-140)/1000000))" is the same as writing "$D22/(($BP22-56-245)*($BQ22-110-140)/1000000)".

Again, if a formula ever feels too long or confusing, then it probably is.