muhammad susanto
Well-known Member
- Joined
- Jan 8, 2013
- Messages
- 2,077
- Office Version
- 365
- 2021
- Platform
- Windows
hi all..
how to make formula for this problem:
note:
if "status" excellent, good, enough and model contains "major" -- showing number 1 if not give me blank/empty cell in column target
if status "bad", worst and model contains "major" or contains mark "-" --showing blank cell in column target
thank for your helping
.susanto
how to make formula for this problem:
status | model | target |
execellent | major | 1 |
good | major | 1 |
execellent | - | blank cell |
enough | major | blank cell |
bad | major | blank cell |
bad | - | blank cell |
note:
if "status" excellent, good, enough and model contains "major" -- showing number 1 if not give me blank/empty cell in column target
if status "bad", worst and model contains "major" or contains mark "-" --showing blank cell in column target
thank for your helping
.susanto