OR FORMULA

[Dazed & Confuzed in my Office]

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?

 

[Gary Brown]

=IF(G4>0,G4*I4,K4)

HTH,
Gary Brown

 

[Don Guillett]

k4*1 or k4*i4??

=if(g4>0,g4,k4)*i4

--
Don Guillett
SalesAid Software
[email protected]
"Dazed & Confuzed in my Office" <Dazed & Confuzed in my
[email protected]> wrote in message
news:[email protected]...

 

[Bob Phillips]

=IF(G4>0,G4*I4,K4)

--

HTH

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


"Dazed & Confuzed in my Office" <Dazed & Confuzed in my
[email protected]> wrote in message
news:[email protected]...