OR FORMULA
 

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?

=IF(G40,G4*I4,K4)

HTH,
Gary Brown


"Dazed & Confuzed in my Office" wrote:

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?

k4*1 or k4*i4??

=if(g40,g4,k4)*i4

--
Don Guillett
SalesAid Software

"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?

=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?