Value Fill

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way that I can have Excel assign a value in one column based on
the value in another column. For example A1 has a value of 15 and A2 has a
value of 90. I would like Excel to recognize that anything in the A column
with a value of 1 to 15 should have a B column value of 575 and any A column
value between 90 and 105 should have a value of 625.

I hope that makes sense. I'm not sure if I need to set up an array or if a
simple formula would suffice. Ideas appreciated to avoid typing out every
possible value of column A and associated column B value in a seperate
worksheet.
 
Put this in B3 and drag down as required:-

=IF(AND(A3>=1,A3<=A$1),575,IF(AND(A3>=A$2,A3<=105),625,"Unspecified"))

because you don't sat what happens for other values in ColA it will return
Unspecified.

Mike
 
Is there a way that I can have Excel assign a value in one column based on
the value in another column. For example A1 has a value of 15 and A2 has a
value of 90. I would like Excel to recognize that anything in the A
column
with a value of 1 to 15 should have a B column value of 575 and any A
column
value between 90 and 105 should have a value of 625.

I hope that makes sense. I'm not sure if I need to set up an array or if
a
simple formula would suffice. Ideas appreciated to avoid typing out every
possible value of column A and associated column B value in a seperate
worksheet.
Click to expand...

While I am sure you will want to handle more value ranges, here is a formula
to do exactly what you asked.

=IF(AND(A1>=1,A1<=15),575,IF(AND(A1>=90,A1<=105),625,"??"))

Put this formula in B1 and then copy it down to the end of your data.

Rick
 
Back
Top