Explore BrainMass
Share

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
    https://brainmass.com/business/management-information-systems/nested-if-function-in-excel-558029

    Attachments

    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.

    $2.19