FORUMLA HELP

[lukeeggy]

I need a formula that will look at a date and if its between certain dates, mark that with certain tex

EXAMPLE

IF C2 (YELLOW) is equal to or less than P3 (ORANGE) it will fill with TEXT1, IF C2 (YELLOW) is less than or equal to P4 (OTHER YELLOW) but greater than P3 (ORANGE), fill with TEXT 2 IN BLUE and so on all the way down to Sep 21

 

[6StringJazzer]

I have no idea where you want this formula to go or what "all the way down" means. With a question like this it helps to mock up your file to show what you want the result to look like.

But the formula for the logic you describe here is:

=IF(C2<=P3,"TEXT1",IF(C2<=P4,"TEXT 2"))

However, you did not say what result you want if C2 is greater than P3 and greater than P4. In that case the result of this formula will be FALSE.

 

[Fluff]

My take on this

=XLOOKUP(C2,P3:P14,L3:L14,"",1)