Someone, please help me to resolve this #VALUE! error in G when E & F are blank
| 2025-03 - W800 Daily Commission (Closed).xlsx | ||||||
|---|---|---|---|---|---|---|
| D | E | F | G | |||
| 1 | #VALUE! | |||||
No Traders Clients | ||||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| D1 | D1 | =IF(ISNA(VLOOKUP(A1,'2025-Mar (Full)'!A:D,2,FALSE)),"",VLOOKUP(A1,'2025-Mar (Full)'!A:D,2,FALSE)) |
| E1 | E1 | =IF(ISNA(VLOOKUP(A1,'2025-Mar (Full)'!A:D,3,FALSE)),"",VLOOKUP(A1,'2025-Mar (Full)'!A:D,3,FALSE)) |
| F1 | F1 | =IF(ISNA(VLOOKUP(A1,'2025-Mar (Full)'!A:D,4,FALSE)),"",VLOOKUP(A1,'2025-Mar (Full)'!A:D,4,FALSE)) |
| G1 | G1 | =IF(E1>0,F1/E1,0) |
| Cells with Conditional Formatting | ||||
|---|---|---|---|---|
| Cell | Condition | Cell Format | Stop If True | |
| D1:F215 | Cell | contains a blank value | text | NO |
| E1:F215 | Other Type | DataBar | NO | |
| D1:D215 | Other Type | DataBar | NO | |
| G1:G215 | Other Type | DataBar | NO | |
