newbieexceldude
New Member
- Joined
- Jan 24, 2014
- Messages
- 3
Hello there
I am very new to this forum, but already have found a lot of great help. Thanks!
However, I have a new problem. I am using the "=if(and(" function, but Excel is rejecting more than 7 functions. I will need at least 20. Is there a way around this?
The data I am working on is as follows:
<tbody>
</tbody>
The formula i've used is: =IF(AND(L4="Certain",N4="Reoccurring"),"Green (1)", IF(AND(L4="Certain",N4="Intermittent"),"Red (2)", IF(AND(L4="Certain",N4="Infrequent"),"Yellow (4)"
Do you have any suggestions?
Thank you very much.
I am very new to this forum, but already have found a lot of great help. Thanks!
However, I have a new problem. I am using the "=if(and(" function, but Excel is rejecting more than 7 functions. I will need at least 20. Is there a way around this?
The data I am working on is as follows:
Certain | Likely | Somewhat | Unlikely | |
Reoccurring | Green | Green | Blue | Blue |
Intermittent | Red | Purple | Red | Red |
Infrequent | Yellow | Pink | Green | Green |
<tbody>
</tbody>
The formula i've used is: =IF(AND(L4="Certain",N4="Reoccurring"),"Green (1)", IF(AND(L4="Certain",N4="Intermittent"),"Red (2)", IF(AND(L4="Certain",N4="Infrequent"),"Yellow (4)"
Do you have any suggestions?
Thank you very much.