if formulas

[J.davis]

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

[Bernard Liengme]

=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

[Bob Phillips]

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

[CLR]

=J4*3%

Vaya con Dios,
Chuck, CABGx3



"J.davis" wrote:

> 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

[CLR]

Sorry, I misread the post............please ignore my offering.

Vaya con Dios,
Chuck, CABGx3



"CLR" wrote:

> =J4*3%
>
> Vaya con Dios,
> Chuck, CABGx3
>
>
>
> "J.davis" wrote:
>
> > 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

[J.davis]

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
>
>
>