Purchase Solution

Nested IF function in Excel

Not what you're looking for?

Ask Custom Question

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.

Attachments
Purchase this Solution
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.

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

Purchase this Solution
Free BrainMass Quizzes
Understanding Management

This quiz will help you understand the dimensions of employee diversity as well as how to manage a culturally diverse workforce.

Managing the Older Worker

This quiz will let you know some of the basics of dealing with older workers. This is increasingly important for managers and human resource workers as many countries are facing an increase in older people in the workforce

MS Word 2010-Tricky Features

These questions are based on features of the previous word versions that were easy to figure out, but now seem more hidden to me.

Introduction to Finance

This quiz test introductory finance topics.

Business Processes

This quiz is intended to help business students better understand business processes, including those related to manufacturing and marketing. The questions focus on terms used to describe business processes and marketing activities.

View More Free Quizzes
Related BrainMass Solutions

  • Nesting in a Program

    The solution to this is to group several nested functions into one user-defined function and those user defined functions will be grouped in the main program and will be called by a one function.

  • Writing query for SQL using NESTED-SELECT statement

    I know that the MAX function finds the highest, but how would I find the second highest income using a NESTED-SELECT statement???

  • C++ sports activity scheduling program

    It also provides an equivalent nested-if implementation of printActivity function for better understanding of printActivity function.

  • Entering a condition equation in Excel

    If you resolve this, the formula should work fine for itself. Just to give you an idea of how the nested if works in Excel : IF(Condition,Value,IF2(condition,Value.....))

  • Computer Programming Code

    Hint: Nested if statements.

  • Simple C++ program using "if" statements.

    This solution shows how to use nested "if" statements in C++. The example program is a voltage transfer function.

  • A simple example of two-dimensional arrays in C

    This solutions provides a simple and easy to understand example of how to use nested for loops to iterate over all of the elements of a two-dimensional array in C.

  • Discussion on ANOVA, t test and F test

    Answer: In the linear model, interaction happens between two independent variables if the effect of one of the variables depends on the level of another variable. All above are just my personal understanding. Just give you some ideas.

  • Real Analysis : Empty Set and Nested Interval Property

    (Notice that this demonstrates that the interval in the Nested Interval Property must be closed for the conclusion of the theorm to hold.) The nested sequence of open bounded intervals, (0,1), (0,1/2), (0,1/3),...(0,1/n),......(0,1/inf.)

View More Related Solutions