Tripleseas
Board Regular
- Joined
- Jul 12, 2022
- Messages
- 87
- Office Version
- 2013
- Platform
- Windows
Hello community,
i have 3 columns in excel
the first column contains numbers and a text " YES"
the second colum contains empty cells(blank) and a text " Double"
i want to write an IF formula in column 3 that can show either "ok" or "not ok" depending on all 4 conditions.
if column 1 is showing numbers and column 2 is empty then not ok , and if column 1 contains YES and column 2 is empty then OK , and if column 1 is YES and column 2 is double then not ok and finnaly if column 1 is numbers and column 2 is double then not ok.
hope that i'm clear. thanks all
i have 3 columns in excel
column 1 | column2 | column3 |
12222 | (blank) | NOT OK |
YES | (blank) | OK |
YES | double | NOT OK |
13444 | double | NOT OK |
the first column contains numbers and a text " YES"
the second colum contains empty cells(blank) and a text " Double"
i want to write an IF formula in column 3 that can show either "ok" or "not ok" depending on all 4 conditions.
if column 1 is showing numbers and column 2 is empty then not ok , and if column 1 contains YES and column 2 is empty then OK , and if column 1 is YES and column 2 is double then not ok and finnaly if column 1 is numbers and column 2 is double then not ok.
hope that i'm clear. thanks all