+ Reply to Thread
Results 1 to 14 of 14

Need Help With A < Formula

Hybrid View

  1. #1
    Forum Expert
    Join Date
    06-26-2010
    Location
    Austin, TX
    MS-Off Ver
    Excel 2010
    Posts
    1,673

    Re: Need Help With A < Formula

    Sorry, but this is still unclear. What does 'in the green' mean? What data is less than 10 (Y31, G31, or something else)? Your current formula has no check on whether or not the data is <10, just if Y31 is >0. Do you care about that check?
    Pauley
    --------
    If I helped with your issue, I'd appreciate a rep bump (hit the '*' icon to the bottom left of this post).

  2. #2
    Registered User
    Join Date
    07-23-2013
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    63

    Re: Need Help With A < Formula

    If Y31 is 10 or less then H31 should be 100%. Anything above 10 then the percentage in H31 should start decreasing. I'm sorry if I'm not describing it clearly enough.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 6
    Last Post: 10-08-2009, 03:45 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1