| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using Excel 2000 VBA Application on Excel 2003 | Excel Worksheet Functions | |||
| How do I write this formula in Excel? | Excel Worksheet Functions | |||
| protecting formula cells in excel 2003 | Excel Discussion (Misc queries) | |||
| sum formula not working, producing incorrect answers Excel 2003 | Excel Discussion (Misc queries) | |||
| How do I get the formula bar in excel 2003 | Excel Discussion (Misc queries) | |||
Hybrid Mode
