Page 1 of 2 12 LastLast
Results 1 to 15 of 18
  1. #1
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Excels most evil function!

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

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    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>
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Excels most evil function!

    How about

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

  4. #4
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    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>
    Regards,
    Rory

    Microsoft MVP - Excel

  5. #5
    5 Star Lounger
    Join Date
    Jul 2004
    Location
    Ohio
    Posts
    629
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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>
    <img src=/w3timages/blueline.gif width=33% height=2>
    <big>John</big>

  6. #6
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    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>
    Jerry

  7. #7
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    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>
    Regards,
    Rory

    Microsoft MVP - Excel

  8. #8
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    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>
    Jerry

  9. #9
    5 Star Lounger
    Join Date
    Jul 2004
    Location
    Ohio
    Posts
    629
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excels most evil function!

    <img src=/S/groan.gif border=0 alt=groan width=16 height=15>
    <img src=/w3timages/blueline.gif width=33% height=2>
    <big>John</big>

  10. #10
    2 Star Lounger
    Join Date
    Jul 2004
    Location
    Hampton, New Hampshire, USA
    Posts
    120
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excels most evil function!

    eVLOOKUP <img src=/S/evilgrin.gif border=0 alt=evilgrin width=15 height=15>
    <font face="Comic Sans MS">MickeyMouse</font face=comic>
    How best to describe the Lounge-
    "Coming together is a beginning, staying together is progress, working together is success"

  11. #11
    4 Star Lounger
    Join Date
    Jan 2002
    Location
    Brookings, South Dakota, USA
    Posts
    449
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excels most evil function!

    any that I make <img src=/S/evilgrin.gif border=0 alt=evilgrin width=15 height=15>
    <IMG SRC=http://www.wopr.com/w3tuserpics/gdrezek_sig.jpg>
    "Those who dance are considered insane by those who can't hear the music" - George Carlin

  12. #12
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    5,016
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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. #13
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    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....
    Regards,
    Rudi

  14. #14
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    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>
    Regards,
    Rudi

  15. #15
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    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>
    Jerry

Page 1 of 2 12 LastLast

Posting Permissions

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