Multiple If Formula
 

Hello to all the experts,

I'm need a formula that says, =If A1<=5,"15.000", If a1=6,"18.000",I
A1=7,"21.000",If A1=8,"24.000",I
A1=9,"27.000",IFA1=10,"30.000",IfA1=11,"33.000",If A1=12,"36.000",I
A1=13,"39.000",If A1=14,"42.000",If A1=15,"45.000",If A1=16,"49.000".
I'm not sure how to tie all of this together in one formula. Help muc
appreciated.

Nathan Sargean

--
Message posted from http://www.ExcelForum.com

Multiple If Formula
 

Hi
setup a lookup table on a separate sheet (e.g. called 'lookup') with
the following structu
A B
0 15.000
6 18.000
7 21.000
....
16 49.000

now use the following formula
=VLOOKUP(A1,'lookup'!$A$1:$B$20,2)


--
Regards
Frank Kabel
Frankfurt, Germany

"natei6 " schrieb im
Newsbeitrag ...
Hello to all the experts,

I'm need a formula that says, =If A1<=5,"15.000", If a1=6,"18.000",If
A1=7,"21.000",If A1=8,"24.000",If
A1=9,"27.000",IFA1=10,"30.000",IfA1=11,"33.000",If A1=12,"36.000",If
A1=13,"39.000",If A1=14,"42.000",If A1=15,"45.000",If
A1=16,"49.000".
I'm not sure how to tie all of this together in one formula. Help
much
appreciated.

Nathan Sargeant


---
Message posted from http://www.ExcelForum.com/

Multiple If Formula
 

Hi Frank,

Thanks for the response, but I'm not sure how that will work with th
different criteria at the beginning and end of the formula, ("=I
(A1<=5,"15.000" )at the beginning and (=If(A1=16,"49.000") at th
end.

Thanks Again

Nathan Sargean

--
Message posted from http://www.ExcelForum.com

Multiple If Formula
 

=IF(A1<=5,15,IF(A1=16,49,A1*3)) , format the cell as a number with
three decimal places.
Formula also assumes that A1 has integers.

natei6 < wrote:
Hello to all the experts,

I'm need a formula that says, =If A1<=5,"15.000", If a1=6,"18.000",If
A1=7,"21.000",If A1=8,"24.000",If
A1=9,"27.000",IFA1=10,"30.000",IfA1=11,"33.000",If A1=12,"36.000",If
A1=13,"39.000",If A1=14,"42.000",If A1=15,"45.000",If A1=16,"49.000".
I'm not sure how to tie all of this together in one formula. Help much
appreciated.

Nathan Sargeant


---
Message posted from http://www.ExcelForum.com/

Multiple If Formula
 

Hi
try the formula. It should work as I use VLOOKUP without FALSE as 4th
parameter. So VLOOKUP will return the value <= the lookup value

--
Regards
Frank Kabel
Frankfurt, Germany

"natei6 " schrieb im
Newsbeitrag ...
Hi Frank,

Thanks for the response, but I'm not sure how that will work with the
different criteria at the beginning and end of the formula, ("=If
(A1<=5,"15.000" )at the beginning and (=If(A1=16,"49.000") at the
end.

Thanks Again

Nathan Sargeant


---
Message posted from http://www.ExcelForum.com/

Multiple If Formula
 

Thanks Frank and JWolf,

Frank, your solution works ok unless A1 is 0, then it says n/a. JWolf
your solution seems to work perfectly without adding another sheet t
the workbook. Is there a reason I should go with the vlookup solution


Thanks again for all the help.

Nathan Sargean

--
Message posted from http://www.ExcelForum.com

Multiple If Formula
 

Just another way without an "If":

=MIN(MAX(15,3*A1),48)+(A1=16)

--
Dana DeLouis
Using Windows XP & Office XP
= = = = = = = = = = = = = = = = =


"natei6 " wrote in message
...
Hello to all the experts,

I'm need a formula that says, =If A1<=5,"15.000", If a1=6,"18.000",If
A1=7,"21.000",If A1=8,"24.000",If
A1=9,"27.000",IFA1=10,"30.000",IfA1=11,"33.000",If A1=12,"36.000",If
A1=13,"39.000",If A1=14,"42.000",If A1=15,"45.000",If A1=16,"49.000".
I'm not sure how to tie all of this together in one formula. Help much
appreciated.

Nathan Sargeant


---
Message posted from http://www.ExcelForum.com/

Multiple If Formula
 

Hi
in your case I would use JWolf's solution. VLOOKUP would be the
prefered solution if you have conditions and results what are not
linked by an algorithmn

--
Regards
Frank Kabel
Frankfurt, Germany

"natei6 " schrieb im
Newsbeitrag ...
Thanks Frank and JWolf,

Frank, your solution works ok unless A1 is 0, then it says n/a.
JWolf,
your solution seems to work perfectly without adding another sheet to
the workbook. Is there a reason I should go with the vlookup
solution?


Thanks again for all the help.

Nathan Sargeant


---
Message posted from http://www.ExcelForum.com/

Multiple If Formula
 

Thanks To All,

I'm a happy camper!

Nathan Sargean

--
Message posted from http://www.ExcelForum.com