Need Help on IF statements

I am trying to create an xls template.

I have it where in like B27, the user enters a numeric varialble. once
that variable is entered, in D27 it will evaluate the value in B27 and
print a set statement.

these variable in B27 are ranges.

like this

if the numeric value is below 6% then print "A" in D27

if the numeric value is between 6% and less than 7% then print "B" in
D27

if the numeric value is between 7% and less than 8% then print "C" in
D27

if the number value is 8% and greater, then print "D" in D27


I hope someone can help me with the syntax for the formula for this. I
have more to do, but with this I can figure the rest out.

Thank you

Jeff


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

Hi
try in D27
=IF(B27=0.08,"D",IF(B27=0.07,"C",IF(B27=0.06,"B ","A")))

or try
=CHAR(66+MAX(INT((B27-0,06)*100),-1))


--
Regards
Frank Kabel
Frankfurt, Germany


I am trying to create an xls template.

I have it where in like B27, the user enters a numeric varialble.
once that variable is entered, in D27 it will evaluate the value in
B27 and print a set statement.

these variable in B27 are ranges.

like this

if the numeric value is below 6% then print "A" in D27

if the numeric value is between 6% and less than 7% then print "B" in
D27

if the numeric value is between 7% and less than 8% then print "C" in
D27

if the number value is 8% and greater, then print "D" in D27


I hope someone can help me with the syntax for the formula for this.
I have more to do, but with this I can figure the rest out.

Thank you

Jeff


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

On Tue, 15 Jun 2004 13:59:21 -0500, JMyers
wrote:

I am trying to create an xls template.

I have it where in like B27, the user enters a numeric varialble. once
that variable is entered, in D27 it will evaluate the value in B27 and
print a set statement.

these variable in B27 are ranges.

like this

if the numeric value is below 6% then print "A" in D27

if the numeric value is between 6% and less than 7% then print "B" in
D27

if the numeric value is between 7% and less than 8% then print "C" in
D27

if the number value is 8% and greater, then print "D" in D27


I hope someone can help me with the syntax for the formula for this. I
have more to do, but with this I can figure the rest out.

Thank you

Jeff

In addition to Frank's answer, you could also use a LOOKUP function. This
might have some advantages if your template becomes more complex. As a
formula:

=VLOOKUP(A1,{0,"A";0.06,"B";0.07,"C";0.08,"D"},2)

but the array constant can also be set up as a table and referred to that way.
See HELP for VLOOKUP for examples.




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

--ron