Spreadsheet: 86621d1286555637-condition-if-statement-mahmuz_multiscenario-1-
Sheet: Sheet1

 | This Example will make my request clear:-
 | Scenario 1
 | Account | Invoice Month | Status | “IF” statement result
 | 94000383 | 2010-01-31 00:00:00 | Paid | Excellent
 | 94000383 | 2010-02-28 00:00:00 | Paid | Excellent
 | 94000383 | 2010-03-31 00:00:00 | Paid | Excellent
 | 94000383 | 2010-04-30 00:00:00 | Paid | Excellent
 | 94000383 | 2010-05-31 00:00:00 | Paid | Excellent
 | 94000383 | 2010-06-30 00:00:00 | Paid | Excellent
 | 94000383 | 2010-07-31 00:00:00 | Paid | Excellent
 | 94000383 | 2010-08-31 00:00:00 | Paid | Excellent
 | Scenario 2
 | Account | Invoice Month | Status | “IF” statement result
 | 94000394 | 2010-01-31 00:00:00 | Not Paid | Very bad
 | 94000394 | 2010-02-28 00:00:00 | Not Paid | Very bad
 | 94000394 | 2010-03-31 00:00:00 | Not Paid | Very bad
 | 94000394 | 2010-04-30 00:00:00 | Not Paid | Very bad
 | 94000394 | 2010-05-31 00:00:00 | Not Paid | Very bad
 | 94000394 | 2010-06-30 00:00:00 | Not Paid | Very bad
 | 94000394 | 2010-07-31 00:00:00 | Not Paid | Very bad
 | 94000394 | 2010-08-31 00:00:00 | Not Paid | Very bad
 | Scenario 3
 | Account | Invoice Month | Status | “IF” statement result
 | 94002323 | 2010-01-31 00:00:00 | Paid | Very bad
 | 94002323 | 2010-02-28 00:00:00 | Not Paid | Very bad
 | 94002323 | 2010-03-31 00:00:00 | Not Paid | Very bad
 | 94002323 | 2010-04-30 00:00:00 | Not Paid | Very bad
 | 94002323 | 2010-05-31 00:00:00 | Not Paid | Very bad
 | 94002323 | 2010-06-30 00:00:00 | Not Paid | Very bad
 | 94002323 | 2010-07-31 00:00:00 | Not Paid | Very bad
 | 94002323 | 2010-08-31 00:00:00 | Not Paid | Very bad
 | Scenario 4
 | Account | Invoice Month | Status | “IF” statement result
 | 94012354 | 2010-01-31 00:00:00 | Paid | Very bad
 | 94012354 | 2010-02-28 00:00:00 | Paid | Very bad
 | 94012354 | 2010-03-31 00:00:00 | Not Paid | Very bad
 | 94012354 | 2010-04-30 00:00:00 | Not Paid | Very bad
 | 94012354 | 2010-05-31 00:00:00 | Not Paid | Very bad
 | 94012354 | 2010-06-30 00:00:00 | Not Paid | Very bad
 | 94012354 | 2010-07-31 00:00:00 | Not Paid | Very bad
 | 94012354 | 2010-08-31 00:00:00 | Not Paid | Very bad
 | Scenario 5
 | Account | Invoice Month | Status | “IF” statement result
 | 94013435 | 2010-01-31 00:00:00 | Paid | Candidate to be bad
 | 94013435 | 2010-02-28 00:00:00 | Paid | Candidate to be bad
 | 94013435 | 2010-03-31 00:00:00 | Paid | Candidate to be bad
 | 94013435 | 2010-04-30 00:00:00 | Not Paid | Candidate to be bad
 | 94013435 | 2010-05-31 00:00:00 | Not Paid | Candidate to be bad
 | 94013435 | 2010-06-30 00:00:00 | Not Paid | Candidate to be bad
 | 94013435 | 2010-07-31 00:00:00 | Not Paid | Candidate to be bad
 | 94013435 | 2010-08-31 00:00:00 | Not Paid | Candidate to be bad
 | Scenario 6
 | Account | Invoice Month | Status | “IF” statement result
 | 94404040 | 2010-01-31 00:00:00 | Paid | Oscillating performance
 | 94404040 | 2010-02-28 00:00:00 | Not Paid | Oscillating performance
 | 94404040 | 2010-03-31 00:00:00 | Paid | Oscillating performance
 | 94404040 | 2010-04-30 00:00:00 | Not Paid | Oscillating performance
 | 94404040 | 2010-05-31 00:00:00 | Not Paid | Oscillating performance
 | 94404040 | 2010-06-30 00:00:00 | Paid | Oscillating performance
 | 94404040 | 2010-07-31 00:00:00 | Not Paid | Oscillating performance
 | 94404040 | 2010-08-31 00:00:00 | Paid | Oscillating performance