Can someone write this formula for me in Excel 2003 Language
 

I want to do this formula: IF H4 = 0 and I4 is than 0, then M4 = K4 times
L4. Can someone help me out by putting it in Excel 2003 language? I sure
wish Excel thought the way I do.
--
SJS

Can someone write this formula for me in Excel 2003 Language
 

in M4 enter
if(and(H4=0,I4<0),K4*L4,"other")

"SJS" wrote:

I want to do this formula: IF H4 = 0 and I4 is than 0, then M4 = K4 times
L4. Can someone help me out by putting it in Excel 2003 language? I sure
wish Excel thought the way I do.
--
SJS

Can someone write this formula for me in Excel 2003 Language
 

This does it if the calculation is in cell M4

=IF(H4=0, IF(I40,K4*L4,""),"")

-John

"SJS" wrote:

I want to do this formula: IF H4 = 0 and I4 is than 0, then M4 = K4 times
L4. Can someone help me out by putting it in Excel 2003 language? I sure
wish Excel thought the way I do.
--
SJS

Can someone write this formula for me in Excel 2003 Language
 

It does. Look in the help index for

IF

--
Don Guillett
SalesAid Software

"SJS" wrote in message
...
I want to do this formula: IF H4 = 0 and I4 is than 0, then M4 = K4
times
L4. Can someone help me out by putting it in Excel 2003 language? I sure
wish Excel thought the way I do.
--
SJS

Can someone write this formula for me in Excel 2003 Language
 

If that answer is a bit too obscure for you, then enter this in cell
M4:

=IF(AND(H4=0,I40),K4*L4,"")

If the condition is not met then the cell will appear blank with this
formula.

Hope this helps.

Pete

Don Guillett wrote:

It does. Look in the help index for

IF

--
Don Guillett
SalesAid Software

"SJS" wrote in message
...
I want to do this formula: IF H4 = 0 and I4 is than 0, then M4 = K4
times
L4. Can someone help me out by putting it in Excel 2003 language? I sure
wish Excel thought the way I do.
--
SJS