jeudi 23 juillet 2020

A thousand nested if/and/or

I have a huge "sheet application", in one row, and one of the fields, called "price" literally has 433 "IF" statements in the formula bar. Basically, there's a lot of options, and based on them, I have to change the price in the field (if user picks option 1, set price 1, and so on). I was just wondering if there was a more sane way of writing that, because

  1. it's seriously tiring and incomprehensible
  2. it usually doesn't even work because I have to throw a IF(AND()) and IF(OR()) from time to time which breaks my workflow, and makes debugging impossible.

Any help greatly appreciated.

Aucun commentaire:

Enregistrer un commentaire