Thread: OR FORMULA
View Single Post
  #4   Report Post  
Bob Phillips
 
Posts: n/a
Default

=IF(G40,G4*I4,K4)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Dazed & Confuzed in my Office" <Dazed & Confuzed in my
wrote in message
...
I am trying to create an IF formula. I want the column M to calculate

G4*I4 if
the value in column G is greater than 0 if not then I want M to calculate

K4*1

Can you help? Is this even possible?