Excel question. 2 sets of value, diameter and volume. how do i put the vol. in 1different col. base on dia<10.?

ok, let me explain in more detail. 2 sets of value, the diameter and volume column. the question is how do i formulate the excel formula to set the different volume value base on 3 different categories of diameter into 3 different columns? eg. if value of diameter =%26lt;40 put the value of volume into diameter =%26lt;40 column. so does the same for the other two columns, eg. =%26gt;80 and =%26gt;120|||If I understand your question correctly, what you need to do is put formulas in those three columns that test your conditions. If the test is passed, then calculate and put the value in the column. For example, put the tests





"=IF(diameter%26lt;=40,volume value,"")"


"=IF(AND(diameter%26gt;40,diameter%26lt;80),volu鈥?value,"")"


"=IF(diameter%26gt;=120,volume value,"")"





in the three columns to get your data placed as you want. ( Are those ranges correct?)