jevi
Active Member
- Joined
- Apr 13, 2010
- Messages
- 339
- Office Version
- 2016
- Platform
- Windows
Hi All,
I am trying to do a formula with if and but I can't achieve what I want. I need if the cell I6 is Tuesday and Wednesday and if cell K5 is equal to 1,2,3,6,8,13,19,22,25 and that the cell K6 is bigger than zero, in case it meets these requirements the cell should be formatted red.
Is a table with the rows date and day of the month and then on the columns Codes which some are 1,2,3,6,8,13,19,22,25 and then I have all the data in tha table.
=+IF(AND($I6="Tuesday";$I6="Thursday";K5=1;K5=2;K5=3;K5=6;K5=8;K5=13;K5=19;K5=22;K5=24;K5=25;K6>0);FALSE)
I can't find a way to make it work.
thnx
I am trying to do a formula with if and but I can't achieve what I want. I need if the cell I6 is Tuesday and Wednesday and if cell K5 is equal to 1,2,3,6,8,13,19,22,25 and that the cell K6 is bigger than zero, in case it meets these requirements the cell should be formatted red.
Is a table with the rows date and day of the month and then on the columns Codes which some are 1,2,3,6,8,13,19,22,25 and then I have all the data in tha table.
=+IF(AND($I6="Tuesday";$I6="Thursday";K5=1;K5=2;K5=3;K5=6;K5=8;K5=13;K5=19;K5=22;K5=24;K5=25;K6>0);FALSE)
I can't find a way to make it work.
thnx