I have a question, I asked a similar question before, and got some great help, but as much as I hate to admit it, wasnt able to figure out how to manipulate it for my newest method of formula flow.
I have several numbers that will equal a certain value if they are within certain range requirements.. example:
(EDIT) they didnt line up in text, had a feeling they wouldnt .. lol
Helms<200 = 2x
201-290= 4x
>291= 8x
Bucklers<55=4x
56-65=8x
66-79=12x
>80=20x
Shields<100= 2x
101-120 = 4x
121-130= 6x
>131=8x
SO.. I will have AL, Shields and Bucklers in 3 different columns, and I need to make a formula that basically says " IF this value in this cell in the bucklers column is 78, then it equals 12"
How would I do that? I have several "IF " for text searches per column that return a value for text matches. I am just unsure how to make it search for a number that is "under/over/within" a range of numbers?
Does this make sense to anyone?
Thanks.. I'm in a major crunch, have to get this inventory done in the next day!
This message was edited by vampcatt on 2002-04-11 11:07
I have several numbers that will equal a certain value if they are within certain range requirements.. example:
(EDIT) they didnt line up in text, had a feeling they wouldnt .. lol
Helms<200 = 2x
201-290= 4x
>291= 8x
Bucklers<55=4x
56-65=8x
66-79=12x
>80=20x
Shields<100= 2x
101-120 = 4x
121-130= 6x
>131=8x
SO.. I will have AL, Shields and Bucklers in 3 different columns, and I need to make a formula that basically says " IF this value in this cell in the bucklers column is 78, then it equals 12"
How would I do that? I have several "IF " for text searches per column that return a value for text matches. I am just unsure how to make it search for a number that is "under/over/within" a range of numbers?
Does this make sense to anyone?
Thanks.. I'm in a major crunch, have to get this inventory done in the next day!
This message was edited by vampcatt on 2002-04-11 11:07