Thread: Can someone write this formula for me in Excel 2003 Language
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bj bj is offline
external usenet poster
  
Posts: 1,397
Default 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
Reply With QuoteReply With Quote