Explore BrainMass

Explore BrainMass

    Entering a condition equation in Excel

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

    In sheet number 4 in cell #I#3 I want to enter this equation:
    If the selected cell in $E$3 is Tloaders or Wloaders, then multiply $G$3 by $A$3.
    If the selected cell in $E$3 is Excavators, then multiply $G$3 by $C$3.

    Solution is attached in the Excel Sheet as well as explained in text document

    © BrainMass Inc. brainmass.com October 9, 2019, 11:45 pm ad1c9bdddf


    Solution Preview

    I have filled in the formula for #I#3, please have a look. I tested with Tloaders in E3 and the formula works fine. When I tested with Wloaders or Excavators, I didn't get ...

    Solution Summary

    The expert provides solution for Excel based conditional.