if formulas
 

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

if formulas
 

In K4 enter

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"J.davis" wrote in message
...
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

if formulas
 

=IF(J40,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" wrote in message
...
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

if formulas
 

=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

if formulas
 

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

if formulas
 

Thank you

"Bernard Liengme" wrote:

=IF(J40,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" wrote in message
...
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