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
|