I am trying to create a formula so that if the information in A1 is within
this range then the result should be this.

A1 = 25
ranges 1-25
then 30 35 40 45 other

I cannot seem to get the formula quite right.

Please help

what do you want to hapen when the values are in that range?


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=518054

I am trying to do a fund raising mailing. So I want to be able to take my
list of what people donated last year and if it was between 0-14.99$ then the
new ask amounts would be 30 35 40 45 other if it was between 15-39.99$ then
the new ask amounts would be 50 55 60 65 other and so on. There are about 6-7
if then situations.


"davesexcel" wrote:


what do you want to hapen when the values are in that range?


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=518054

I don't see why you have multiple amounts 30, 35, 40 ,45 but perhaps a
LOOKUP would work for you, it's generally easier when you have multiple
possibilities

=LOOKUP(A1,{0,15,30,45;30,50,70,90})

You'd have to put in the exact values you need but in my example if A1
contains anything above 0 but less than 15 formula returns 30, if 15 to
30 returns 50, if 30 to 45 returns 70 etc. Any ggod to you?


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=518054

Have you ever received something in the mail from someone looking for money
(cystic fibrosis, alzheimers, etc) and on the enclosed card there is a spot
where you can check a preset amount. that is what I am trying to do. what
you gave me seems like a good start but I need the values after the : to be a
series of cells in order for everything to print out correctly.
In order to get it to print out like this
_ 30 _ 35 _ 40 _45
I have to have each of those values in individual cells.

the above would be what I want to print if the person donated between 0 - 15
dollars last year.

"daddylonglegs" wrote:


I don't see why you have multiple amounts 30, 35, 40 ,45 but perhaps a
LOOKUP would work for you, it's generally easier when you have multiple
possibilities

=LOOKUP(A1,{0,15,30,45;30,50,70,90})

You'd have to put in the exact values you need but in my example if A1
contains anything above 0 but less than 15 formula returns 30, if 15 to
30 returns 50, if 30 to 45 returns 70 etc. Any ggod to you?


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=518054

hey there. after looking at the spreadsheet again and a little thinking,
your formula worked out wonderfully. I just had to figure out how to
implement it. thank you very much for your help.

"daddylonglegs" wrote:


I don't see why you have multiple amounts 30, 35, 40 ,45 but perhaps a
LOOKUP would work for you, it's generally easier when you have multiple
possibilities

=LOOKUP(A1,{0,15,30,45;30,50,70,90})

You'd have to put in the exact values you need but in my example if A1
contains anything above 0 but less than 15 formula returns 30, if 15 to
30 returns 50, if 30 to 45 returns 70 etc. Any ggod to you?


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=518054