how do you set up an if, then formula in excel??
 

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

how do you set up an if, then formula in excel??
 

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

how do you set up an if, then formula in excel??
 

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

how do you set up an if, then formula in excel??
 

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

how do you set up an if, then formula in excel??
 

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

how do you set up an if, then formula in excel??
 

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