On Thu, 7 Aug 2008 09:55:02 -0700, Cat
wrote:

I need the formula to come back with certain money when the cell above has a
certain number. This is the formula I have =IF(D5=2,3,0)(D5=2,3,0). If the
cell above has a 2 in it it should have $3 come back. If it has a 3 or
higher it should have $5 come back. If the cell is lower than 2 it should
have $0.
Please see example below:
C D E F G H
-------------------------------------------------------------
John Doe 3 2 1 4 0 <-------------------Condition
-------------------------------------------------------------
$5 $3 $0 $5 $0 <-----------------Formula
------------------------------------------------------------
PLEASE HELP!

Assuming that there are only integers in D5
you may try this formula:

=IF(D5<2,0,IF(D5=2,3,5))

Hope this helps / Lars-Åke