Explore BrainMass

Explore BrainMass

    Nested IF function in Excel

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    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 October 10, 2019, 6:49 am 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.