Formulas for calculate number of days depending on list of value
I need to know if it is feasible to obtain this formula :
In a sheet, i can choose several option from a list of value ( checkboxes).
If option A is checked, i add 1.5 days for ex. If i choose B, i add 1 day. If i choose A & B, i obtain 2.5. And so one.
How can i create that in one formula? Any idea?
Many thanks in advance !!
Help Article Resources
Check out the Formula Handbook template!