Navigation

    Links

    • Login
    • Search
    • Categories
    • Recent
    • Tags
    1. Home
    2. Recent
    Log in to post
    • All categories
    • Welcome
    •      Announcements
    •      Terms of Use
    •      User Guide
    •      Questions/Feedback
    •      Privacy Policy
    • Matt
    • Nick
    • Imogen
    • eraserman
    • PrivilegedUser
    • Mimi
    • All Topics
    • New Topics
    • Watched Topics
    • Unreplied Topics

    • How to...
      Matt • • Matt  

      90
      0
      Votes
      90
      Posts
      64901
      Views

      How to show fold changes in an excel spreadsheet when there are 0 values in the denominator. In the example below P30 is the numerator and P2 is the denominator. The logic is: Both numerator and denominator = 0 → output 0.00 Denominator = 0, numerator ≠ 0 → output >{numerator} (2 decimals) Numerator = 0, denominator ≠ 0 → output <{denominator} (2 decimals) Otherwise → output normal division with 2 decimals. =IF(AND(P30=0,P2=0),"0.00", IF(P2=0,">"&TEXT(P30,"0.00"), IF(P30=0,"<"&TEXT(P2,"0.00"), TEXT(P30/P2,"0.00"))))
    • Links
      Matt • • Matt  

      26
      0
      Votes
      26
      Posts
      14472
      Views

      Turing machine simulator
    • Flower Photos
      Matt • • Matt  

      23
      0
      Votes
      23
      Posts
      11439
      Views

    • Sky Photos
      Matt • • Matt  

      8
      0
      Votes
      8
      Posts
      2296
      Views

    • Sunrise and Sunset Photos
      Matt • • Matt  

      16
      0
      Votes
      16
      Posts
      4380
      Views

    • What
      Matt • • Matt  

      6
      0
      Votes
      6
      Posts
      1702
      Views

      What is the cause of the following error when trying to run a NextFlow script: illegal string body character after dollar sign; solution: either escape a literal dollar sign "\$5" or bracket the value expression "${5}" @ line 3170, column 43. This error occurs when you forget to escape a $ sign in a script block.
    • Japan Photos
      Matt • • Matt  

      52
      0
      Votes
      52
      Posts
      31981
      Views

    • Whatever
      Matt • • Matt  

      1
      0
      Votes
      1
      Posts
      640
      Views

      No one has replied

    • Whatever Photos
      Matt • • Matt  

      45
      0
      Votes
      45
      Posts
      25994
      Views

      E

      @Matt said in Whatever Photos: this too a fav
    • Nature Photos
      Matt • • Matt  

      9
      0
      Votes
      9
      Posts
      2528
      Views

    • Videos
      Matt • • Matt  

      2
      0
      Votes
      2
      Posts
      833
      Views

    • Georgia Tech OMSA (Georgia Institute of Technology Online Master of Science in Analytics)
      Matt • • Matt  

      7
      0
      Votes
      7
      Posts
      2992
      Views

      Brief MGT6203 Review MGT6203 "Data Analytics for Business" is an easy A if your work/family/other commitments permit it. The program was quite useful to consolidate regression model, forecasting and queue theory. In addition, learning the fundamentals of factor investing and measuring risk adjusted performance was a particular highlight for me. I also learned a thing or two about digital marketing and it was great that Professor Bien regularly chatted with his students.
    • Boxing Photos
      Matt • • Matt  

      22
      0
      Votes
      22
      Posts
      11669
      Views

    • 3D-Models
      Matt • • Matt  

      1
      0
      Votes
      1
      Posts
      699
      Views

      No one has replied

    • Lists
      Matt • • Matt  

      1
      0
      Votes
      1
      Posts
      702
      Views

      No one has replied

    • How to create topics and replies and upload files
      User Guide • • Administrator  

      1
      0
      Votes
      1
      Posts
      5114
      Views

      No one has replied

    • How to format a link
      User Guide • • Administrator  

      1
      0
      Votes
      1
      Posts
      816
      Views

      No one has replied

    • Important Links
      Mimi • • Administrator  

      1
      0
      Votes
      1
      Posts
      294
      Views

      No one has replied

    • Other People's Music
      Matt • • Matt  

      1
      0
      Votes
      1
      Posts
      804
      Views

      No one has replied

    • 3D Protein Structures
      Matt • • Matt  

      1
      0
      Votes
      1
      Posts
      766
      Views

      No one has replied