| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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) |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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) |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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) |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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) |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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) |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to combine formulas to......... | Excel Worksheet Functions | |||
| Using an IF to combine multiple formulas | Excel Discussion (Misc queries) | |||
| Combine 2 formulas | Excel Worksheet Functions | |||
| How do you combine 2 or more formulas with different totals? | Excel Discussion (Misc queries) | |||
| Help combine 2 formulas into 1 | Excel Worksheet Functions | |||
Hybrid Mode
