Purchase Solution

Entering a condition equation in Excel

Not what you're looking for?

Ask Custom Question

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

Attachments
Purchase this Solution

Solution Summary

The expert provides solution for Excel based conditional.

Solution Preview

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

Purchase this Solution


Free BrainMass Quizzes
Java loops

This quiz checks your knowledge of for and while loops in Java. For and while loops are essential building blocks for all Java programs. Having a solid understanding of these constructs is critical for success in programming Java.

C++ Operators

This quiz tests a student's knowledge about C++ operators.

Basic UNIX commands

Use this quiz to check your knowledge of a few common UNIX commands. The quiz covers some of the most essential UNIX commands and their basic usage. If you can pass this quiz then you are clearly on your way to becoming an effective UNIX command line user.

Excel Introductory Quiz

This quiz tests your knowledge of basics of MS-Excel.

Basic Networking Questions

This quiz consists of some basic networking questions.