| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Formula
If the cell on which a formula is based is 0 or empty, I want the result that
is shown to be blank. How do I build that into the formula? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel Formula
=IF(A1=0,"",A1)
Hope this helps. Pete Pat wrote: If the cell on which a formula is based is 0 or empty, I want the result that is shown to be blank. How do I build that into the formula? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel Formula
That almost does the trick. Here is the formula I am working with: =(c4-b4)+1 If there is nothing in b4, how do I make the "if" statement work? "Pete_UK" wrote: =IF(A1=0,"",A1) Hope this helps. Pete Pat wrote: If the cell on which a formula is based is 0 or empty, I want the result that is shown to be blank. How do I build that into the formula? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel Formula
=IF(OR(B4="",B4=0),"",C4-B4+1)
"Pat" wrote: If the cell on which a formula is based is 0 or empty, I want the result that is shown to be blank. How do I build that into the formula? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Reusing formula | Excel Discussion (Misc queries) | |||
| Excel Formula Issue | Excel Discussion (Misc queries) | |||
| Match then lookup | Excel Worksheet Functions | |||
| converting formula from lotus.123 to excel | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
Linear Mode
