if formulas

J

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
 
B

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

CLR

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

Vaya con Dios,
Chuck, CABGx3
 
Top