Try:

=IF(D6=2,2,IF(D62,5,0))

Or:

=(D61)*2+(D62)*3


--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Cat" wrote in message
...
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!
--
Thank you so much!