I need some help with som this formula in a cell.
=IF(AND($J15-NOW()>=0;$J15-NOW()<=3);"test1";"");IF(AND($J15-NOW()>=4;$J15-NOW()<=6);"test2";"");IF(AND($J15-NOW()>=7;$J15-NOW()<=9);"test3";"")
I have some conditional formating to color the Row if it meets the criteria. But I also need a TEXT in one of the cells based on that criteria. I have 4 cryteria.
Does this make any sense :-)
Bookmarks