Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
#Div/0!
Futher to my message earlier H4 has the following equation:
=IF(AND(F40,G40),"",IF(F40,PI()*E4/(6.5*F4),PI()*E4/G4)) Values E,F,G are all input. How do i get the cell H to display 0 when E equals zero |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
#Div/0!
Trying to find which other post to look in was a bit of a nightmare because
you have so many on the same subject. However, I assume in this one you are trying to eliminate the division/0 error in which case it has nothing to do with E, it occurs when both F&G=0 so try this:- =IF(AND(F40,G40),"",IF(AND(F4=0,G4=0),"",IF(F40 ,PI()*E4/(6.5*F4),PI()*E4/G4))) Mike "David" wrote: Futher to my message earlier H4 has the following equation: =IF(AND(F40,G40),"",IF(F40,PI()*E4/(6.5*F4),PI()*E4/G4)) Values E,F,G are all input. How do i get the cell H to display 0 when E equals zero |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
#Div/0!
Futher to my message earlier H4 has the following equation:
=IF(AND(F40,G40),"",IF(F40,PI()*E4/(6.5*F4),PI()*E4/G4)) Values E,F,G are all input. How do i get the cell H to display 0 when E equals zero Unless I am missing something, based on the above equation, it looks like H4 will always be zero whenever E4 is zero since E4. What are you seeing that prompted you to ask the question that you did? Rick |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
#Div/0!
The only way you would get a divide by zero is if F4 and G4 are both zero
(and in that case you wouldn't have got to that point if you had used some of the answers to some of your earlier questions). You could protect for that in the same way you have against F4 being zero (or by one of the earlier suggestions), or you could test specifically for E4 being zero. -- David Biddulph "David" wrote in message ... Futher to my message earlier H4 has the following equation: =IF(AND(F40,G40),"",IF(F40,PI()*E4/(6.5*F4),PI()*E4/G4)) Values E,F,G are all input. How do i get the cell H to display 0 when E equals zero |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|