|
|
#3
10-06-2021, 05:14 PM
|
|||
|
|||
hi, p45cal
appreciate your help. I have just tested the sample that u attached. I found out the result dint really match what I want because the result only G & Y. those R also turned to Y. do you mind to take a look again? G = there is totally NO negative value on Row Name "Proj OH" in between date Y = if 1 or 2 negative value on Row Name "Proj OH" between Col C - Col P R = if 3 or more negative value on Row Name "Proj OH" between Col C - Col P and negative value on Col Q - Col S. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Need Conditional based percentage formula! | jocky6688 | Excel | 5 | 03-15-2021 12:35 AM |
| Formula to return a value of 1,2,3 or based on a set criteria | Highlander01 | Excel | 7 | 06-02-2017 01:17 PM |
 Need a formula to set a field based on two variables
|
unknownhere2000 | Excel | 2 | 01-12-2016 01:05 PM |
| Custom formatting to make negative numbers show w/o negative sign on charts | todor | PowerPoint | 3 | 01-16-2013 03:45 AM |
|
If formula result is negative then display text
|
oxicottin | Excel | 3 | 12-03-2012 02:12 AM |
Windows 10 
Office 2019
Threaded Mode