An Excel "If And" Spreadsheet
Not what you're looking for?
Please see the attached.....it is an advanced material balance model I am working on but I need help in one area to complete it.
I am trying to accomplish the following --- so if you look at my attached document:
In Cell K13, I want a calculated value based on the following:
If the Product Code entered in Cell G5 is "A", then I want the formula for cell K13 to be: (I5*4.1667*60)/1000)/60*D5*.015
If the Product Code entered in Cell G5 is "B", then I want the formula for cell K13 to be: (I5*4.1667*60)/1000)/60*D6*.015
I presently have a formula in cell K13 but please ignore....I want it to be as I've described above.
How can this be written and I presume it is an "IF AND" type of formula --- can you please write how this formula should appear??
Many thanks and I appreciate your help in advance!
Purchase this Solution
Solution Summary
"If and" statements are created in Ecel. The response was rated '5/5' by the student who posted the question originally.
Solution Preview
K13 =IF(G5="A", ((I5*4.1667*60)/1000)/60*D5*0.015,IF(G5="B",((I5*4.1667*60)/1000)/60*D6*0.015))
If G5 = "A" is true, the program ...
Purchase this Solution
Free BrainMass Quizzes
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.
C++ Operators
This quiz tests a student's knowledge about C++ operators.
C# variables and classes
This quiz contains questions about C# classes and variables.
Inserting and deleting in a linked list
This quiz tests your understanding of how to insert and delete elements in a linked list. Understanding of the use of linked lists, and the related performance aspects, is an important fundamental skill of computer science data structures.
Javscript Basics
Quiz on basics of javascript programming language.