Explore BrainMass
Share

# An Excel "If And" Spreadsheet

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

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

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

#### Solution Summary

"If and" statements are created in Ecel. The response was rated '5/5' by the student who posted the question originally.

\$2.19