Create a two column table elsewhere with the possible rates in one column,
loan types in the next, then use

=VLOOKUP(rate,lookup_table,2,False)


--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Stockwell43" wrote in message
...
Hello,

My boss needs me to do an IF statment on a spreadsheet. Here is what I
need:

In the Column "Interest Rate" the cells are percentages 0.00%, 5.50%,
2.25%
and so on. In the Loan Type Column are the loan types depending on the
Percentage Rate.

What I need is this:
If Interest rate is 0.00% then Loan Tpye is "Letter of Credit"

How do I get Excel to do this if the user enters 0.00% in the interest
rate
column?

Thanks!!