The first IF gives #DIV/0!

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"driller" wrote in message
...
hi sir bob,

i tried to prepare another if statement until i encounter an eye blocking
question
starting with this formula

=IF(OR(G4<=0,D4=""),"",IF(ISERROR(D4+G4),G4,G4+D4) )

with a test data as follows:

G4=-5
D4=#DIV/0 "1/0"

My formula result is #DIV/0!
but by reading the first If with an OR : the result i must get is
literally
"" [blank]....

perhaps i miss something...any ideas...

regards
driller
--
*****
birds of the same feather flock together..



"Bob Phillips" wrote:

=IF(ISERROR(G4+D4),ROUNDUP(G4,1),IF(OR(G4="",D4="" ),"",IF(OR(ROUNDUP(G4,1)<=0),"",ROUNDUP(G4,1)+D4)) )

perhaps?

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)



"Dennis1188" wrote in message
...
I need help joining this...

=IF(ISERROR(G4+D4),G4,IF(OR(G4="",D4=""),"",IF(OR( G4<=0),"",G4+D4)))

with this...

ROUNDUP(G4,1)