Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HELP please... easy function
Hi,
I have a problem. Here is the main formula: =(A5*B5)/C5 but if there is nothing( blank) in cells A5 and C5 i got #DIV/0! I don't want to have this error #DIV/0!, i just want that IF cells A5 and C5 are blank result 0 (ZERO). I tried with that formula but is not working: =IF(A5="blank";0;(A5*B5)/C5) Can anyone help me please? Thanks a lot |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HELP please... easy function
=IF(C5=0;0;A5*B5/C5)
-- David Biddulph "JoZo" wrote in message ... Hi, I have a problem. Here is the main formula: =(A5*B5)/C5 but if there is nothing( blank) in cells A5 and C5 i got #DIV/0! I don't want to have this error #DIV/0!, i just want that IF cells A5 and C5 are blank result 0 (ZERO). I tried with that formula but is not working: =IF(A5="blank";0;(A5*B5)/C5) Can anyone help me please? Thanks a lot |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HELP please... easy function
"JoZo" wrote:
I don't want to have this error #DIV/0!, i just want that IF cells A5 and C5 are blank result 0 (ZERO). The following might be sufficient: =IF(C5=0, 0, A5*B5/C5) No need to test if A5 or B5 is zero. The original formula takes care that, since 0*y is zero, and 0/x is zero as long as x is non-zero. However, you might need: =IF(N(C5)=0, 0, A5*B5/C5) or even better: =IF(OR(C5=0,COUNT(A5:C5)<3), 0, A5*B5/C5) Sometimes, a cell __appears__ empty, but it actually contains text which is the null string, the result of the following very common paradigm: =IF(something,"",something). In that case, the original formula might result in a #VALUE! error. ----- original message ----- "JoZo" wrote in message ... Hi, I have a problem. Here is the main formula: =(A5*B5)/C5 but if there is nothing( blank) in cells A5 and C5 i got #DIV/0! I don't want to have this error #DIV/0!, i just want that IF cells A5 and C5 are blank result 0 (ZERO). I tried with that formula but is not working: =IF(A5="blank";0;(A5*B5)/C5) Can anyone help me please? Thanks a lot |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HELP please... easy function
Try this
=IF(A5=0,"",(A5*B5)/C5) You seem to be using ; in your version of Excel where I use , so make the necessary changes to suit your region. Mike "JoZo" wrote: Hi, I have a problem. Here is the main formula: =(A5*B5)/C5 but if there is nothing( blank) in cells A5 and C5 i got #DIV/0! I don't want to have this error #DIV/0!, i just want that IF cells A5 and C5 are blank result 0 (ZERO). I tried with that formula but is not working: =IF(A5="blank";0;(A5*B5)/C5) Can anyone help me please? Thanks a lot . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
easy function quesiton | Excel Worksheet Functions | |||
Easy IF Function | Excel Discussion (Misc queries) | |||
Sum function question - easy? | Excel Worksheet Functions | |||
Function question (probably easy) | Excel Discussion (Misc queries) | |||
Easy function question | Excel Discussion (Misc queries) |