Can you please help with this spreadsheet? If you could show me how to do it and what the end product looks like, that would be great. Thank you.
Note: The nested IF function must have these parameters:
IF( condition1, value_if_true1, IF( condition2, value_if_true2, value_if_false2 ))
In your problem then can be expressed in:
=IF(D6=4,C6*J9, IF(D6=3,C6*J8, IF(D6=2,C6*J7, C6*J6)))
Which is similar to this ...
This is a step-by-step instruction in using the nested IF function in spreadsheet. The attached spreadsheet file shows how this is applied.