Explore BrainMass

Nested IF function in Excel

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.

© BrainMass Inc. brainmass.com July 20, 2018, 10:26 pm ad1c9bdddf


Solution Preview

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 ...

Solution Summary

This is a step-by-step instruction in using the nested IF function in spreadsheet. The attached spreadsheet file shows how this is applied.