| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Nested if statement problem!
Hi i have been given a nested if statement by Aaron as below and modified it to the bottom statement so that it accumilates 8hrs ever instance it finds in a named range however the only part that works i the first section for 8hours but not the latter for 12 hours, can yo help? Thanks! Simon IF(COUNTIF(Hols1,"Bloggs J"),COUNTIF(Hols1,"Blogg J")+8,IF(COUNTIF(Hols2,"Bloggs J"),COUNTIF(Hols1,"Bloggs J")+12,0)) =IF(COUNTIF(Hols1,"Bloggs J"),COUNTIF(Hols1,"Blogg J")*8,IF(COUNTIF(Hols2,"Bloggs J"),COUNTIF(Hols2,"Bloggs J")*12,0) -- Simon Lloy ----------------------------------------------------------------------- Simon Lloyd's Profile: http://www.excelforum.com/member.php...nfo&userid=670 View this thread: http://www.excelforum.com/showthread.php?threadid=39090 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Nested if statement problem!
All sorted now thanks to Toppers! =COUNTIF(Hols1,"Bloggs J")*8+COUNTIF(Hols2,"Bloggs J")*1 -- Simon Lloy ----------------------------------------------------------------------- Simon Lloyd's Profile: http://www.excelforum.com/member.php...nfo&userid=670 View this thread: http://www.excelforum.com/showthread.php?threadid=39090 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Nested IF statement | Excel Discussion (Misc queries) | |||
| Nested if statement ? | Excel Worksheet Functions | |||
| NESTED IF STATEMENT | Excel Worksheet Functions | |||
| Problem with nested IF_OR statement | Excel Worksheet Functions | |||
| 7+ nested if statement? | Excel Worksheet Functions | |||
![Simon Lloyd[_634_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
