| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiplying Empty Cells
In cell N15, I am using this formula M15*24. However sometimes M15 is blank
and when it is I get a message in cell N15 that says #VALUE!. Which throws off other formulas. I need help adding an IF statement to this formula M15*24 so that cell N15 in which the formula is located will become blank or 0 when M15 does not have a value/is blank. Biff and JE McGimpsey recommended I use =IF(COUNT(K15:L15)<2,"" for a similar problem I had while subtracting dates and it has worked awesome. I tried adding it to the current formula and I came up with =IF(COUNT(M4)<2,"",(M4*24)-1) but I didnt get the same result which is the blank cell I was looking for. Any thoughts? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting text cells then multiplying by a value in another column | Excel Worksheet Functions | |||
| Multiplying cells with formula's | New Users to Excel | |||
| Formulas for multiplying cells | Excel Worksheet Functions | |||
| Excel - Autom. Filter "Empty / Non Empty cells" should come first | Excel Discussion (Misc queries) | |||
| How can I convert empty strings to empty cells? | Excel Discussion (Misc queries) | |||
Threaded Mode
