Thank you

"Bernard Liengme" wrote:

> =IF(J4>0,P4*3%,0)
> This will also return 0 if J4 is negative
> best wishes
> --
> Bernard V Liengme
> www.stfx.ca/people/bliengme
> remove caps from email
>
> "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
>
>
>