|
|
#7
10-13-2021, 04:54 PM
|
|||
|
|||
Quote:
I'd like you to tell me: 1. Which 3 or more cells contain the negative values to get that R result in just that one cell AB17 AB17 is month JAN, and cell Q1 is the only JAN to indicate with. its unable to compare 3 or not to indicate R. with one cell only, shld be either R or G 2. Which cells should just that cell AB17 examine to see if they are negative or not. as mentioned above AB17 is JAN, from Col C - Col V, only Col Q is JAN, so shld be either R or G 
|
|
|
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