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

 

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

 

[Bernard Liengme]

=IF(J4>0,P4*3%,0)
This will also return 0 if J4 is negative
best wishes

 

[CLR]

=J4*3%

Vaya con Dios,
Chuck, CABGx3

 

[CLR]

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

Vaya con Dios,
Chuck, CABGx3

 

[J.davis]

Thank you

=IF(J4>0,P4*3%,0)
This will also return 0 if J4 is negative
best wishes