| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Percentage equals 0 error
I know if I ask for the percentage of =G44/H44 and both columns contain a 0,
or H44 contains a 0, Excel will return a #DIV/0! error. Is there anyway to override that and display 0% until I actually get the numbers in there from a database query I need to run, which may be later in the year? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Percentage equals 0 error
One way...
=IF(OR(H44=0,COUNT(G44:H44)<2),0,G44/H44) -- Biff Microsoft Excel MVP "Richard Horn" wrote in message ... I know if I ask for the percentage of =G44/H44 and both columns contain a 0, or H44 contains a 0, Excel will return a #DIV/0! error. Is there anyway to override that and display 0% until I actually get the numbers in there from a database query I need to run, which may be later in the year? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Percentage equals 0 error
Try =IF(ISERROR(G44/H44),0,G44/H44)
-- Ken Hudson "Richard Horn" wrote: I know if I ask for the percentage of =G44/H44 and both columns contain a 0, or H44 contains a 0, Excel will return a #DIV/0! error. Is there anyway to override that and display 0% until I actually get the numbers in there from a database query I need to run, which may be later in the year? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Percentage equals 0 error
Can't you get away with just =IF(H44=0,0,G44/H44) ?
[Unless, of course, there is text in G44?] -- David Biddulph "T. Valko" wrote in message ... One way... =IF(OR(H44=0,COUNT(G44:H44)<2),0,G44/H44) -- Biff Microsoft Excel MVP "Richard Horn" wrote in message ... I know if I ask for the percentage of =G44/H44 and both columns contain a 0, or H44 contains a 0, Excel will return a #DIV/0! error. Is there anyway to override that and display 0% until I actually get the numbers in there from a database query I need to run, which may be later in the year? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Percentage equals 0 error
Can't you get away with just =IF(H44=0,0,G44/H44) ?
[Unless, of course, there is text in G44?] Yes, but you could also get away with just this if you wanted to: =IF(H44,G44/H44,0) That's why the first line in my reply was: One way... -- Biff Microsoft Excel MVP "David Biddulph" <groups [at] biddulph.org.uk wrote in message ... Can't you get away with just =IF(H44=0,0,G44/H44) ? [Unless, of course, there is text in G44?] -- David Biddulph "T. Valko" wrote in message ... One way... =IF(OR(H44=0,COUNT(G44:H44)<2),0,G44/H44) -- Biff Microsoft Excel MVP "Richard Horn" wrote in message ... I know if I ask for the percentage of =G44/H44 and both columns contain a 0, or H44 contains a 0, Excel will return a #DIV/0! error. Is there anyway to override that and display 0% until I actually get the numbers in there from a database query I need to run, which may be later in the year? |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Percentage equals 0 error
"T. Valko" wrote
in response to "David Biddulph" <groups [at] biddulph.org.uk: Can't you get away with just =IF(H44=0,0,G44/H44) ? [....] Yes, but you could also get away with just this if you wanted to: =IF(H44,G44/H44,0) That returns an error if H44 is the null string. I thought that might be why you had included the COUNT condition. But the following covers both adequately: =IF(N(H44),N(G44)/H44,0) ----- original message ----- "T. Valko" wrote in message ... Can't you get away with just =IF(H44=0,0,G44/H44) ? [Unless, of course, there is text in G44?] Yes, but you could also get away with just this if you wanted to: =IF(H44,G44/H44,0) That's why the first line in my reply was: One way... -- Biff Microsoft Excel MVP "David Biddulph" <groups [at] biddulph.org.uk wrote in message ... Can't you get away with just =IF(H44=0,0,G44/H44) ? [Unless, of course, there is text in G44?] -- David Biddulph "T. Valko" wrote in message ... One way... =IF(OR(H44=0,COUNT(G44:H44)<2),0,G44/H44) -- Biff Microsoft Excel MVP "Richard Horn" wrote in message ... I know if I ask for the percentage of =G44/H44 and both columns contain a 0, or H44 contains a 0, Excel will return a #DIV/0! error. Is there anyway to override that and display 0% until I actually get the numbers in there from a database query I need to run, which may be later in the year? |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Percentage equals 0 error
Good grief!
What part of "one way" don't you folks understand? <bg <bg means "big grin". As in a big joking #$%^ eating grin. -- Biff Microsoft Excel MVP "Joe User" <joeu2004 wrote in message ... "T. Valko" wrote in response to "David Biddulph" <groups [at] biddulph.org.uk: Can't you get away with just =IF(H44=0,0,G44/H44) ? [....] Yes, but you could also get away with just this if you wanted to: =IF(H44,G44/H44,0) That returns an error if H44 is the null string. I thought that might be why you had included the COUNT condition. But the following covers both adequately: =IF(N(H44),N(G44)/H44,0) ----- original message ----- "T. Valko" wrote in message ... Can't you get away with just =IF(H44=0,0,G44/H44) ? [Unless, of course, there is text in G44?] Yes, but you could also get away with just this if you wanted to: =IF(H44,G44/H44,0) That's why the first line in my reply was: One way... -- Biff Microsoft Excel MVP "David Biddulph" <groups [at] biddulph.org.uk wrote in message ... Can't you get away with just =IF(H44=0,0,G44/H44) ? [Unless, of course, there is text in G44?] -- David Biddulph "T. Valko" wrote in message ... One way... =IF(OR(H44=0,COUNT(G44:H44)<2),0,G44/H44) -- Biff Microsoft Excel MVP "Richard Horn" wrote in message ... I know if I ask for the percentage of =G44/H44 and both columns contain a 0, or H44 contains a 0, Excel will return a #DIV/0! error. Is there anyway to override that and display 0% until I actually get the numbers in there from a database query I need to run, which may be later in the year? |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Percentage equals 0 error
"T. Valko" wrote:
Good grief! What part of "one way" don't you folks understand? <bg Next time I'll write "here's another way" or "here's an improvement" for those who don't get that that is implicit as always. <bg ----- original message ----- "T. Valko" wrote in message ... Good grief! What part of "one way" don't you folks understand? <bg <bg means "big grin". As in a big joking #$%^ eating grin. -- Biff Microsoft Excel MVP "Joe User" <joeu2004 wrote in message ... "T. Valko" wrote in response to "David Biddulph" <groups [at] biddulph.org.uk: Can't you get away with just =IF(H44=0,0,G44/H44) ? [....] Yes, but you could also get away with just this if you wanted to: =IF(H44,G44/H44,0) That returns an error if H44 is the null string. I thought that might be why you had included the COUNT condition. But the following covers both adequately: =IF(N(H44),N(G44)/H44,0) ----- original message ----- "T. Valko" wrote in message ... Can't you get away with just =IF(H44=0,0,G44/H44) ? [Unless, of course, there is text in G44?] Yes, but you could also get away with just this if you wanted to: =IF(H44,G44/H44,0) That's why the first line in my reply was: One way... -- Biff Microsoft Excel MVP "David Biddulph" <groups [at] biddulph.org.uk wrote in message ... Can't you get away with just =IF(H44=0,0,G44/H44) ? [Unless, of course, there is text in G44?] -- David Biddulph "T. Valko" wrote in message ... One way... =IF(OR(H44=0,COUNT(G44:H44)<2),0,G44/H44) -- Biff Microsoft Excel MVP "Richard Horn" wrote in message ... I know if I ask for the percentage of =G44/H44 and both columns contain a 0, or H44 contains a 0, Excel will return a #DIV/0! error. Is there anyway to override that and display 0% until I actually get the numbers in there from a database query I need to run, which may be later in the year? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| count if equals first non error cell | Excel Worksheet Functions | |||
| Validation - Error message if equals Left formula | Excel Worksheet Functions | |||
| If a cell equals _, at the next row that equals _, return value fr | Excel Worksheet Functions | |||
| if a:a (range) equals january and c:c equals gas then add g:g ($) | Excel Worksheet Functions | |||
| custom filter does not work when selecting 'equals' X AND 'equals' | Excel Discussion (Misc queries) | |||
![Richard Horn[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
