abdelfattah
Well-known Member
- Joined
- May 3, 2019
- Messages
- 1,429
- Office Version
- 2019
- 2010
- Platform
- Windows
I try designing formula by IF function but doesn't work my formula in column g based on column e if is column e = - then show the result in column g "paid" and if column e = numbers then show "unpaid
note : I exchange "- " instead of 0 from bar ribbon by formatting 0;-0;-;@
note : I exchange "- " instead of 0 from bar ribbon by formatting 0;-0;-;@
VBA Code:
=IF(E2<>"0";"paid";"unpaid")
ws.xlsm | |||||||||
---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | |||
1 | date | name | inv no | case | paid | remained | case | ||
2 | 01/10/2020 | ali | as123 | paid | - | 2200 | paid | ||
3 | 02/10/2020 | omar | as124 | unpaid | - | 1232 | paid | ||
4 | 03/11/2020 | ali | asd123 | paid | 22 | 264 | paid | ||
5 | 04/11/2020 | omar | asd124 | unpaid | - | 264 | paid | ||
6 | 05/11/2020 | mahmoud | asd125 | paid | 1000 | 264 | paid | ||
7 | 06/12/2020 | khalid | asd126 | unpaid | - | 264 | paid | ||
8 | 07/12/2020 | ahmed | asd127 | paid | 1000 | 264 | paid | ||
9 | 08/12/2020 | muneer | asd128 | unpaid | - | 264 | paid | ||
10 | |||||||||
source |
Cell Formulas | ||
---|---|---|
Range | Formula | |
G2:G9 | G2 | =IF(E2<>"0","paid","unpaid") |