| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
show 0.00 if referenced cell is empty
this formula =2240/(B9*7.2) will show an error until something is entered
into cell B9 I would like it to be 0.00 until B9 is populated, how is this done? Thanks, David |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
show 0.00 if referenced cell is empty
On Jun 26, 2:07 pm, "David D" wrote:
this formula =2240/(B9*7.2) will show an error until something is entered into cell B9 I would like it to be 0.00 until B9 is populated, how is this done? Thanks, David =IF(ISNUMBER(B9),2240/(B9*7.2),0) Mark Lincoln |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
show 0.00 if referenced cell is empty
=IF(B9="",0,2240/(B9*7.2))
__________________________________________________ _____________________ "David D" wrote in message ... this formula =2240/(B9*7.2) will show an error until something is entered into cell B9 I would like it to be 0.00 until B9 is populated, how is this done? Thanks, David |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
show 0.00 if referenced cell is empty
Try this:
=IF(B9="",0,2240/(B9*7.2)) HTH, Elkar "David D" wrote: this formula =2240/(B9*7.2) will show an error until something is entered into cell B9 I would like it to be 0.00 until B9 is populated, how is this done? Thanks, David |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
show 0.00 if referenced cell is empty
That works great until I try to use it in a cell that adds 2 cell together;
Cell B9= empty or blank cell Cell B10= no error msg. where I have the formula, =IF(ISNUMBER(B9),2240/(B9*7.2),0) Cell B22= =SUM(B9,B16) Cell B23= #DIV/0! where I have the formula, =IF(ISNUMBER(B9),2240/(B9*7.2),0) "Mark Lincoln" wrote in message oups.com... On Jun 26, 2:07 pm, "David D" wrote: this formula =2240/(B9*7.2) will show an error until something is entered into cell B9 I would like it to be 0.00 until B9 is populated, how is this done? Thanks, David =IF(ISNUMBER(B9),2240/(B9*7.2),0) Mark Lincoln |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
show 0.00 if referenced cell is empty
Cell B23 in your second example should produce exactly the same result
as cell B10 in the first example; it's the same formula. Should it have referred to cell B22? Regardless, I didn't test for zero in my original reply. Here's an amended formula: =IF(AND(ISNUMBER(B9),B9<0),2240/(B9*7.2),0) This sets the result to zero unless cell B9 is both numeric and nonzero. Sorry for the trouble. Mark Lincoln On Jun 26, 3:47 pm, "David D" wrote: That works great until I try to use it in a cell that adds 2 cell together; Cell B9= empty or blank cell Cell B10= no error msg. where I have the formula, =IF(ISNUMBER(B9),2240/(B9*7.2),0) Cell B22= =SUM(B9,B16) Cell B23= #DIV/0! where I have the formula, =IF(ISNUMBER(B9),2240/(B9*7.2),0) "Mark Lincoln" wrote in message oups.com... On Jun 26, 2:07 pm, "David D" wrote: this formula =2240/(B9*7.2) will show an error until something is entered into cell B9 I would like it to be 0.00 until B9 is populated, how is this done? Thanks, David =IF(ISNUMBER(B9),2240/(B9*7.2),0) Mark Lincoln- Hide quoted text - - Show quoted text - |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
show 0.00 if referenced cell is empty
Mark, Thanks that worked fine...
David "Mark Lincoln" wrote in message ps.com... Cell B23 in your second example should produce exactly the same result as cell B10 in the first example; it's the same formula. Should it have referred to cell B22? Regardless, I didn't test for zero in my original reply. Here's an amended formula: =IF(AND(ISNUMBER(B9),B9<0),2240/(B9*7.2),0) This sets the result to zero unless cell B9 is both numeric and nonzero. Sorry for the trouble. Mark Lincoln On Jun 26, 3:47 pm, "David D" wrote: That works great until I try to use it in a cell that adds 2 cell together; Cell B9= empty or blank cell Cell B10= no error msg. where I have the formula, =IF(ISNUMBER(B9),2240/(B9*7.2),0) Cell B22= =SUM(B9,B16) Cell B23= #DIV/0! where I have the formula, =IF(ISNUMBER(B9),2240/(B9*7.2),0) "Mark Lincoln" wrote in message oups.com... On Jun 26, 2:07 pm, "David D" wrote: this formula =2240/(B9*7.2) will show an error until something is entered into cell B9 I would like it to be 0.00 until B9 is populated, how is this done? Thanks, David =IF(ISNUMBER(B9),2240/(B9*7.2),0) Mark Lincoln- Hide quoted text - - Show quoted text - |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
show 0.00 if referenced cell is empty
shorter version
=IF(B9,2240/(B9*7.2),0) "Mark Lincoln" wrote: Cell B23 in your second example should produce exactly the same result as cell B10 in the first example; it's the same formula. Should it have referred to cell B22? Regardless, I didn't test for zero in my original reply. Here's an amended formula: =IF(AND(ISNUMBER(B9),B9<0),2240/(B9*7.2),0) This sets the result to zero unless cell B9 is both numeric and nonzero. Sorry for the trouble. Mark Lincoln On Jun 26, 3:47 pm, "David D" wrote: That works great until I try to use it in a cell that adds 2 cell together; Cell B9= empty or blank cell Cell B10= no error msg. where I have the formula, =IF(ISNUMBER(B9),2240/(B9*7.2),0) Cell B22= =SUM(B9,B16) Cell B23= #DIV/0! where I have the formula, =IF(ISNUMBER(B9),2240/(B9*7.2),0) "Mark Lincoln" wrote in message oups.com... On Jun 26, 2:07 pm, "David D" wrote: this formula =2240/(B9*7.2) will show an error until something is entered into cell B9 I would like it to be 0.00 until B9 is populated, how is this done? Thanks, David =IF(ISNUMBER(B9),2240/(B9*7.2),0) Mark Lincoln- Hide quoted text - - Show quoted text - |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
show 0.00 if referenced cell is empty
That works as long as B9 is blank or a number, but produces a #VALUE!
error if B9 is nonnumeric, i.e., text. I would rather most of my users see a zero result as opposed to the error message--they don't panic nearly as badly. ;) Mark Lincoln On Jun 26, 11:22 pm, Teethless mama wrote: shorter version =IF(B9,2240/(B9*7.2),0) "Mark Lincoln" wrote: Cell B23 in your second example should produce exactly the same result as cell B10 in the first example; it's the same formula. Should it have referred to cell B22? Regardless, I didn't test for zero in my original reply. Here's an amended formula: =IF(AND(ISNUMBER(B9),B9<0),2240/(B9*7.2),0) This sets the result to zero unless cell B9 is both numeric and nonzero. Sorry for the trouble. Mark Lincoln On Jun 26, 3:47 pm, "David D" wrote: That works great until I try to use it in a cell that adds 2 cell together; Cell B9= empty or blank cell Cell B10= no error msg. where I have the formula, =IF(ISNUMBER(B9),2240/(B9*7.2),0) Cell B22= =SUM(B9,B16) Cell B23= #DIV/0! where I have the formula, =IF(ISNUMBER(B9),2240/(B9*7.2),0) "Mark Lincoln" wrote in message roups.com... On Jun 26, 2:07 pm, "David D" wrote: this formula =2240/(B9*7.2) will show an error until something is entered into cell B9 I would like it to be 0.00 until B9 is populated, how is this done? Thanks, David =IF(ISNUMBER(B9),2240/(B9*7.2),0) Mark Lincoln- Hide quoted text - - Show quoted text -- Hide quoted text - - Show quoted text - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| using a vlookup, can i use isblank to show an empty cell | Excel Worksheet Functions | |||
| Using if function to show blank when cell in other sheet is empty | Excel Worksheet Functions | |||
| How are empty cells referenced in Excel in IF statements? | Excel Worksheet Functions | |||
| why a reference to an empty cell is not considered empty | Excel Discussion (Misc queries) | |||
| Need cells to show as zero or empty | Excel Worksheet Functions | |||
Linear Mode
