=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