software

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: www.excelforum.com/member.php...oamp;userid=31708
View this thread: www.excelforum.com/showthread...hreadid=518054I 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.quot;davesexcelquot; wrote:

gt;
gt; what do you want to hapen when the values are in that range?
gt;
gt;
gt; --
gt; davesexcel
gt; ------------------------------------------------------------------------
gt; davesexcel's Profile: www.excelforum.com/member.php...oamp;userid=31708
gt; View this thread: www.excelforum.com/showthread...hreadid=518054
gt;
gt;


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: www.excelforum.com/member.php...oamp;userid=30486
View this thread: www.excelforum.com/showthread...hreadid=518054Have 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.

quot;daddylonglegsquot; wrote:

gt;
gt; I don't see why you have multiple amounts 30, 35, 40 ,45 but perhaps a
gt; LOOKUP would work for you, it's generally easier when you have multiple
gt; possibilities
gt;
gt; =LOOKUP(A1,{0,15,30,45;30,50,70,90})
gt;
gt; You'd have to put in the exact values you need but in my example if A1
gt; contains anything above 0 but less than 15 formula returns 30, if 15 to
gt; 30 returns 50, if 30 to 45 returns 70 etc. Any ggod to you?
gt;
gt;
gt; --
gt; daddylonglegs
gt; ------------------------------------------------------------------------
gt; daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
gt; View this thread: www.excelforum.com/showthread...hreadid=518054
gt;
gt;

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.

quot;daddylonglegsquot; wrote:

gt;
gt; I don't see why you have multiple amounts 30, 35, 40 ,45 but perhaps a
gt; LOOKUP would work for you, it's generally easier when you have multiple
gt; possibilities
gt;
gt; =LOOKUP(A1,{0,15,30,45;30,50,70,90})
gt;
gt; You'd have to put in the exact values you need but in my example if A1
gt; contains anything above 0 but less than 15 formula returns 30, if 15 to
gt; 30 returns 50, if 30 to 45 returns 70 etc. Any ggod to you?
gt;
gt;
gt; --
gt; daddylonglegs
gt; ------------------------------------------------------------------------
gt; daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
gt; View this thread: www.excelforum.com/showthread...hreadid=518054
gt;
gt;