Nestled Formulas

  • Thread starter Thread starter hodkd
  • Start date Start date
H

hodkd

If you look at my attahced spread sheet you will see I have several
variables on the left and on the top. I would like to combine all of
those variables in one formula, such as
=IF(AND(F20<2001,H20<76),C8,"")+IF(AND(F20<2001,H20>75,H20<86,D8,"")...on
through the top variables and then start on the next varible on the
left, such as
=IF(AND(F20>2000,F20<4001,H20<76),C9,"")+IF(AND(F20>2000,F20<4001,H20>75,H20<86),D9,"")...then
repeat with each varialbe on the top and to the left. I see I can get
them to work in individual cells but can they be combined into one
cell?

File Attached: http://www.exceltip.com/forum/attachment.php?postid=292764 (braking template calculator chart only.xls)
 
Things being the way they are, with seemingly every other attachment or link
being a potential virus, you probably would not want help from anyone stupid
enough to open it. Please do not attach files to a binary newsgroup.

--
Greeting from the Gulf Coast!
http://myweb.cableone.net/twodays
hodkd said:
If you look at my attahced spread sheet you will see I have several
variables on the left and on the top. I would like to combine all of
those variables in one formula, such as
=IF(AND(F20<2001,H20<76),C8,"")+IF(AND(F20<2001,H20>75,H20<86,D8,"")...on
through the top variables and then start on the next varible on the
left, such as
Click to expand...
=IF(AND(F20>2000 said:
repeat with each varialbe on the top and to the left. I see I can get
them to work in individual cells but can they be combined into one
cell?

File Attached: http://www.exceltip.com/forum/attachment.php?postid=292764
Click to expand...
(braking template calculator chart only.xls)
 
Rather, please do not attach files to a non-binary newsgroup. (like
this). Attaching files to binary groups is what they exist for.
 
Back
Top