In K4 enter

=IF(J4=0,0,IF(J4>0,p4*3%,"don't know what to do if J4 <0"))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"J.davis" <J.davis@discussions.microsoft.com> wrote in message
news:53556256-BCF7-4A29-B309-A49D5974C456@microsoft.com...
> i am trying to create a conditional formula to
>
> if cell j4 is greater than 0 multiply cell p4 by 3%, if cell j4 is zero
> return a result of zero. i want the calculation to be in cell k4
> any help would be appriciated
> J. Davis