Let's see. This is homework so you should come up with the answer yourself.
Did you start by looking in the help index for IF. There are good examples
that should get you an "A".

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

wrote in message
...
Having a little problem in an excel class, hoping someone might be
able to help. I'm trying to fill in the discount column on a
spreadsheet with the following info. The problem states use a nested
form of the IF function to calculate 15% if Amount is greater that
$300., 10% if Amount is greater than $100., and 0% if Amount is less
than $100. The Amount column is cell D5. Anyone know how to write the
formula and explain how to go about it? Any help would be much
appreciated.