# Thread: Excels most evil function!

1. ## Excels most evil function!

Whats the MOST evil function in Excel??? <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

2. ## Re: Excels most evil function!

<span style="background-color: #FFFF00; color: #FFFF00; font-weight: bold">SIN</span hide>? <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

3. ## Re: Excels most evil function!

=(mround((IF(OR(DAY(FED)=1,DAY(FED)=16),FED,IF(DAY (FED)>15,DATE(YEAR(FED),MONTH(FED),16),DATE(YEAR(F ED),MONTH(FED),1)))-IF(OR(DAY(FBD)=1,DAY(FBD)=16),FBD,IF(DAY(FBD)>15,D ATE(YEAR(FBD),MONTH(FBD)+1,1),DATE(YEAR(FBD),MONTH (FBD),16)))-1)/15,0.5)+(networkdays(IF(OR(DAY(FED)=1,DAY(FED)=16) ,FED,IF(DAY(FED)>15,DATE(YEAR(FED),MONTH(FED),16), DATE(YEAR(FED),MONTH(FED),1))),FED)/networkdays(IF(OR(DAY(FED)=1,DAY(FED)=16),FED,IF(D AY(FED)>15,DATE(YEAR(FED),MONTH(FED),16),DATE(YEAR (FED),MONTH(FED),1))),DATE(YEAR(FED),MONTH(FED)+IF (DAY(FED)>15,1,0),IF(DAY(FED)>15,0,15))))+(network days(FBD,IF(OR(DAY(FBD)=1,DAY(FBD)=16),FBD,IF(DAY( FBD)>15,DATE(YEAR(FBD),MONTH(FBD)+1,1),DATE(YEAR(F BD),MONTH(FBD),16)))-1)/networkdays(DATE(YEAR(FBD),MONTH(FBD),IF(DAY(FBD)> 15,15,1)),IF(OR(DAY(FBD)=1,DAY(FBD)=16),FBD,IF(DAY (FBD)>15,DATE(YEAR(FBD),MONTH(FBD)+1,1),DATE(YEAR( FBD),MONTH(FBD),16)))-1)))*(AR/24)

4. ## Re: Excels most evil function!

You forgot the error check:
=IF(ISERROR((mround((IF(OR(DAY(FED)=1,DAY(FED)=16) ,FED,IF(DAY(FED)>15,DATE(YEAR(FED),MONTH(FED),16), DATE(YEAR(FED),MONTH(FED),1)))-IF(OR(DAY(FBD)=1,DAY(FBD)=16),FBD,IF(DAY(FBD)>15,D ATE(YEAR(FBD),MONTH(FBD)+1,1),DATE(YEAR(FBD),MONTH (FBD),16)))-1)/15,0.5)+(networkdays(IF(OR(DAY(FED)=1,DAY(FED)=16) ,FED,IF(DAY(FED)>15,DATE(YEAR(FED),MONTH(FED),16), DATE(YEAR(FED),MONTH(FED),1))),FED)/networkdays(IF(OR(DAY(FED)=1,DAY(FED)=16),FED,IF(D AY(FED)>15,DATE(YEAR(FED),MONTH(FED),16),DATE(YEAR (FED),MONTH(FED),1))),DATE(YEAR(FED),MONTH(FED)+IF (DAY(FED)>15,1,0),IF(DAY(FED)>15,0,15))))+(network days(FBD,IF(OR(DAY(FBD)=1,DAY(FBD)=16),FBD,IF(DAY( FBD)>15,DATE(YEAR(FBD),MONTH(FBD)+1,1),DATE(YEAR(F BD),MONTH(FBD),16)))-1)/networkdays(DATE(YEAR(FBD),MONTH(FBD),IF(DAY(FBD)> 15,15,1)),IF(OR(DAY(FBD)=1,DAY(FBD)=16),FBD,IF(DAY (FBD)>15,DATE(YEAR(FBD),MONTH(FBD)+1,1),DATE(YEAR( FBD),MONTH(FBD),16)))-1)))*(AR/24)),0,(mround((IF(OR(DAY(FED)=1,DAY(FED)=16),FED, IF(DAY(FED)>15,DATE(YEAR(FED),MONTH(FED),16),DATE( YEAR(FED),MONTH(FED),1)))-IF(OR(DAY(FBD)=1,DAY(FBD)=16),FBD,IF(DAY(FBD)>15,D ATE(YEAR(FBD),MONTH(FBD)+1,1),DATE(YEAR(FBD),MONTH (FBD),16)))-1)/15,0.5)+(networkdays(IF(OR(DAY(FED)=1,DAY(FED)=16) ,FED,IF(DAY(FED)>15,DATE(YEAR(FED),MONTH(FED),16), DATE(YEAR(FED),MONTH(FED),1))),FED)/networkdays(IF(OR(DAY(FED)=1,DAY(FED)=16),FED,IF(D AY(FED)>15,DATE(YEAR(FED),MONTH(FED),16),DATE(YEAR (FED),MONTH(FED),1))),DATE(YEAR(FED),MONTH(FED)+IF (DAY(FED)>15,1,0),IF(DAY(FED)>15,0,15))))+(network days(FBD,IF(OR(DAY(FBD)=1,DAY(FBD)=16),FBD,IF(DAY( FBD)>15,DATE(YEAR(FBD),MONTH(FBD)+1,1),DATE(YEAR(F BD),MONTH(FBD),16)))-1)/networkdays(DATE(YEAR(FBD),MONTH(FBD),IF(DAY(FBD)> 15,15,1)),IF(OR(DAY(FBD)=1,DAY(FBD)=16),FBD,IF(DAY (FBD)>15,DATE(YEAR(FBD),MONTH(FBD)+1,1),DATE(YEAR( FBD),MONTH(FBD),16)))-1)))*(AR/24))

<img src=/S/evilgrin.gif border=0 alt=evilgrin width=15 height=15>

5. ## Re: Excels most evil function!

<span style="background-color: #FFFF00; color: #FFFF00; font-weight: bold">POISON()</span hide> <img src=/S/laugh.gif border=0 alt=laugh width=15 height=15>

6. ## Re: Excels most evil function!

<img src=/S/megashout.gif border=0 alt=megashout width=33 height=17> OI....IS THAT A RUDI SPELLING MISTAKE...IT'S <span style="background-color: #FFFF00; color: #FFFF00; font-weight: bold">POISSON</span hide>....anyway why are fish evil? <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>

7. ## Re: Excels most evil function!

<span style="background-color: #FFFF00; color: #FFFF00; font-weight: bold">
RANK</span hide>?
<span style="background-color: #FFFF00; color: #FFFF00; font-weight: bold">PMT</span hide>? <img src=/S/flee.gif border=0 alt=flee width=25 height=25>

8. ## Re: Excels most evil function!

Weeeel if I had a range called Dracula, I could have Count(Dracula)....he is pretty evil <img src=/S/evilgrin.gif border=0 alt=evilgrin width=15 height=15>

9. ## Re: Excels most evil function!

<img src=/S/groan.gif border=0 alt=groan width=16 height=15>

10. ## Re: Excels most evil function!

eVLOOKUP <img src=/S/evilgrin.gif border=0 alt=evilgrin width=15 height=15>

11. ## Re: Excels most evil function!

any that I make <img src=/S/evilgrin.gif border=0 alt=evilgrin width=15 height=15>

12. ## Re: Excels most evil function!

All depends on your point-of-view really. As they say in France, "One man's fish is another man's poisson". <img src=/S/flee.gif border=0 alt=flee width=25 height=25>

Alan

13. ## Re: Excels most evil function!

The usual inventiveness of the loungers have come up with some VERY VALID options.... <img src=/S/yep.gif border=0 alt=yep width=15 height=15>

However, there is yet another Function NAME (sorry Jezza) that is more evil that any mentioned to date. Let me give you a little more time to see if you can come up with the function....

14. ## Re: Excels most evil function!

Here is the answer: Excels most evil function is: <span style="background-color: #FFFF00; color: #FFFF00; font-weight: bold">DMIN</span hide> <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

15. ## Re: Excels most evil function!

<img src=/S/bif.gif border=0 alt=bif width=70 height=28> DMIN <img src=/S/pun.gif border=0 alt=pun width=22 height=18> <img src=/S/rofl.gif border=0 alt=rofl width=15 height=15>

Page 1 of 2 12 Last

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•