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

K

kdw

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
 
K

kdw

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.
 
D

daddylonglegs

I don't see why you have multiple amounts 30, 35, 40 ,45 but perhaps
LOOKUP would work for you, it's generally easier when you have multipl
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 A
contains anything above 0 but less than 15 formula returns 30, if 15 t
30 returns 50, if 30 to 45 returns 70 etc. Any ggod to you
 
K

kdw

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.
 
K

kdw

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.
 
Top