| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What IF - formula question
I need help with an IF formula question. My cell has a formula in it
=sum(H43/G43). I want this cell blank If the result is not a percentage (the cell has been formatted to be a %). When I drag the formula to many other cells some of them are #DIV/O! and I want those cells to be blank. I cant figure out how to do this. Thanks for your time and help! -- Gene |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
What IF - formula question
I think you mean something like:
=IF(G43=0,"",H43/G43) Hope this helps. Pete Gene wrote: I need help with an IF formula question. My cell has a formula in it =sum(H43/G43). I want this cell blank "" If the result is not a percentage (the cell has been formatted to be a %). When I drag the formula to many other cells some of them are #DIV/O! and I want those cells to be blank. I can't figure out how to do this. Thanks for your time and help! -- Gene |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
What IF - formula question
except I need the G43=0 to include + & - results. I only need #div/0! to be
shown as nothing. -- Gene "Pete_UK" wrote: I think you mean something like: =IF(G43=0,"",H43/G43) Hope this helps. Pete Gene wrote: I need help with an IF formula question. My cell has a formula in it =sum(H43/G43). I want this cell blank "" If the result is not a percentage (the cell has been formatted to be a %). When I drag the formula to many other cells some of them are #DIV/O! and I want those cells to be blank. I can't figure out how to do this. Thanks for your time and help! -- Gene |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
What IF - formula question
If G43 does equal zero, then you will get #DIV/0! because you are
trying to divide by zero - the formula I suggested intercepts this and returns a blank instead. You can't get any + & - results when G43 = 0. Perhaps you need to re-phrase the problem and what it is you are trying to achieve. Pete Gene wrote: except I need the G43=0 to include + & - results. I only need #div/0! to be shown as nothing. -- Gene "Pete_UK" wrote: I think you mean something like: =IF(G43=0,"",H43/G43) Hope this helps. Pete Gene wrote: I need help with an IF formula question. My cell has a formula in it =sum(H43/G43). I want this cell blank "" If the result is not a percentage (the cell has been formatted to be a %). When I drag the formula to many other cells some of them are #DIV/O! and I want those cells to be blank. I can't figure out how to do this. Thanks for your time and help! -- Gene |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
What IF - formula question
when i create the formula below and drag it down many rows there are rows
that have no info or words in the rows. these rows create a #div/0! result. those are the rows that i want blank. the dozens of other rows with figures may have a result in the positive or negative in the formula result. if i am not clear i will start over completely. thanks Pete_UK for taking the time. -- Gene "Pete_UK" wrote: If G43 does equal zero, then you will get #DIV/0! because you are trying to divide by zero - the formula I suggested intercepts this and returns a blank instead. You can't get any + & - results when G43 = 0. Perhaps you need to re-phrase the problem and what it is you are trying to achieve. Pete Gene wrote: except I need the G43=0 to include + & - results. I only need #div/0! to be shown as nothing. -- Gene "Pete_UK" wrote: I think you mean something like: =IF(G43=0,"",H43/G43) Hope this helps. Pete Gene wrote: I need help with an IF formula question. My cell has a formula in it =sum(H43/G43). I want this cell blank "" If the result is not a percentage (the cell has been formatted to be a %). When I drag the formula to many other cells some of them are #DIV/O! and I want those cells to be blank. I can't figure out how to do this. Thanks for your time and help! -- Gene |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
What IF - formula question
Have you tried Pete's suggestion? It works for me.
=IF(G43=0,"",H43/G43) "Gene" wrote in message ... when i create the formula below and drag it down many rows there are rows that have no info or words in the rows. these rows create a #div/0! result. those are the rows that i want blank. the dozens of other rows with figures may have a result in the positive or negative in the formula result. if i am not clear i will start over completely. thanks Pete_UK for taking the time. -- Gene "Pete_UK" wrote: If G43 does equal zero, then you will get #DIV/0! because you are trying to divide by zero - the formula I suggested intercepts this and returns a blank instead. You can't get any + & - results when G43 = 0. Perhaps you need to re-phrase the problem and what it is you are trying to achieve. Pete Gene wrote: except I need the G43=0 to include + & - results. I only need #div/0! to be shown as nothing. -- Gene "Pete_UK" wrote: I think you mean something like: =IF(G43=0,"",H43/G43) Hope this helps. Pete Gene wrote: I need help with an IF formula question. My cell has a formula in it =sum(H43/G43). I want this cell blank "" If the result is not a percentage (the cell has been formatted to be a %). When I drag the formula to many other cells some of them are #DIV/O! and I want those cells to be blank. I can't figure out how to do this. Thanks for your time and help! -- Gene |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
What IF - formula question
Yes it works for me too. I had tried it several times but was entering the
data in a wrong column. Thanks David & Pete. I am so impressed with assistance by many the 3-4 times I've posted here. Again thanks. Gene -- Gene "David F Cox" wrote: Have you tried Pete's suggestion? It works for me. =IF(G43=0,"",H43/G43) "Gene" wrote in message ... when i create the formula below and drag it down many rows there are rows that have no info or words in the rows. these rows create a #div/0! result. those are the rows that i want blank. the dozens of other rows with figures may have a result in the positive or negative in the formula result. if i am not clear i will start over completely. thanks Pete_UK for taking the time. -- Gene "Pete_UK" wrote: If G43 does equal zero, then you will get #DIV/0! because you are trying to divide by zero - the formula I suggested intercepts this and returns a blank instead. You can't get any + & - results when G43 = 0. Perhaps you need to re-phrase the problem and what it is you are trying to achieve. Pete Gene wrote: except I need the G43=0 to include + & - results. I only need #div/0! to be shown as nothing. -- Gene "Pete_UK" wrote: I think you mean something like: =IF(G43=0,"",H43/G43) Hope this helps. Pete Gene wrote: I need help with an IF formula question. My cell has a formula in it =sum(H43/G43). I want this cell blank "" If the result is not a percentage (the cell has been formatted to be a %). When I drag the formula to many other cells some of them are #DIV/O! and I want those cells to be blank. I can't figure out how to do this. Thanks for your time and help! -- Gene |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
What IF - formula question
You're welcome, Gene - keep posting!
Pete Gene wrote: Yes it works for me too. I had tried it several times but was entering the data in a wrong column. Thanks David & Pete. I am so impressed with assistance by many the 3-4 times I've posted here. Again thanks. Gene -- Gene "David F Cox" wrote: Have you tried Pete's suggestion? It works for me. =IF(G43=0,"",H43/G43) "Gene" wrote in message ... when i create the formula below and drag it down many rows there are rows that have no info or words in the rows. these rows create a #div/0! result. those are the rows that i want blank. the dozens of other rows with figures may have a result in the positive or negative in the formula result. if i am not clear i will start over completely. thanks Pete_UK for taking the time. -- Gene "Pete_UK" wrote: If G43 does equal zero, then you will get #DIV/0! because you are trying to divide by zero - the formula I suggested intercepts this and returns a blank instead. You can't get any + & - results when G43 = 0. Perhaps you need to re-phrase the problem and what it is you are trying to achieve. Pete Gene wrote: except I need the G43=0 to include + & - results. I only need #div/0! to be shown as nothing. -- Gene "Pete_UK" wrote: I think you mean something like: =IF(G43=0,"",H43/G43) Hope this helps. Pete Gene wrote: I need help with an IF formula question. My cell has a formula in it =sum(H43/G43). I want this cell blank "" If the result is not a percentage (the cell has been formatted to be a %). When I drag the formula to many other cells some of them are #DIV/O! and I want those cells to be blank. I can't figure out how to do this. Thanks for your time and help! -- Gene |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula question | Excel Worksheet Functions | |||
| Repeating Formula Question | Excel Discussion (Misc queries) | |||
| Newbie Question - Subtraction Formula Question | Excel Discussion (Misc queries) | |||
| Match then lookup | Excel Worksheet Functions | |||
| I have a question regarding countif formula. | Excel Worksheet Functions | |||
Linear Mode
