mykal66
09-26-2018, 08:44 PM
Hi everyone
I can do multiple if statments based on cells values in a single cell but can anyone tell me if it's possible to do an IF statement where it looks at 2 different cells?
I have a spreadsheet at work where i want the status to changes to OPEN as soon as a date is entered in one cell but then change to CLOSED when a second date is entered into the adjascent cell.
I treid IF OR but it just keeps returning OPEN even with both dates completed. Example uploaded.
As usual, thank you in advance for any pointers - you guys have helped me many times in the past and it is always appreciated.
Mykal22935
I can do multiple if statments based on cells values in a single cell but can anyone tell me if it's possible to do an IF statement where it looks at 2 different cells?
I have a spreadsheet at work where i want the status to changes to OPEN as soon as a date is entered in one cell but then change to CLOSED when a second date is entered into the adjascent cell.
I treid IF OR but it just keeps returning OPEN even with both dates completed. Example uploaded.
As usual, thank you in advance for any pointers - you guys have helped me many times in the past and it is always appreciated.
Mykal22935