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
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 ...
The expert provides solution for Excel based conditional.