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?
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).
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks