EXCEL - IF Formula: Multiple Conditions, H6 Cell, SUM Function (Welcome & Guide)

dt1 wrote:

If you did not make a mistake in your example and in the case of "1" you do d23-d4, and in other cases you do d23-x (x will be some value), then you will have to apply the condition for one and the rest to do the rest (variant 2 in my example). If you have a bug and in case 1 you also want to do d4-d23, you can do it even more without a condition (variant 1 of my example). The "slack" variant takes advantage of the fact that the cells to perform the action are closely related to the numerical value of the cell being checked (exactly every stitch you go down two rows lower), so you can afford something like that.

Alternatively, variant 3, where you do everything on foot, but not nesting IF functions, but combining their results. The conditions are precise so neither will occur twice, as a result you always get 8 blank characters and one answer as a result. The result is treated as text, so I closed everything in the VALUE function, which converts this text to a number. Variant 3 produces the same results as Variant 2. Variant 3 works all the time without nesting, so there is no limit of 6 items.