Share
Explore BrainMass

An Excel "If And" Spreadsheet

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!

Attachments

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