Simple If

=IF(A3=5,9,IF(A3=6,12,IF(A3=55,30,"")))

in A5 and format as $ amount.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"AndyS" wrote in message
...
In need to us something similar to IF function but to have multiple
answers ie
if A3=5 then A5=$9
If A3=6 then A5=$12
IF A3=55 Then A5=$30
Any help would be greatly appreciated