Combine Formulas
 

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)

Combine Formulas
 

Where do you expect them to "combine"?

Perhaps one way:

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

but I don't understand what you're trying to trap with ISERROR() - will
G4 or D4 contain an error? If G4 contains either an error or text,
ROUNDUP(G4,1) will pass on the error...

In article ,
Dennis1188 wrote:

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)

Combine Formulas
 

=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)

Combine Formulas
 

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)

Combine Formulas
 

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)

Combine Formulas
 

Hi Sir Bob,

its a first time for me, is there any logical reason for this considering
that we are using a Logical function...or are there any available readings
for function limitation other than the 7ifs...

really surprised...i hope i can remember this later, and avoid any
suggestive formulas in this forum...

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



"Bob Phillips" wrote:

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)