Combine Formulas

D

Dennis1188

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

JE McGimpsey

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...
 
B

Bob Phillips

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

driller

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
 
B

Bob Phillips

The first IF gives #DIV/0!

--
---
HTH

Bob

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



driller said:
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 said:
=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)
Click to expand...
Click to expand...
 
D

driller

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 said:
The first IF gives #DIV/0!

--
---
HTH

Bob

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



driller said:
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 said:
=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)



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)
Click to expand...
Click to expand...
Click to expand...
 
Top