Formula for Cell D3
=IF(C3>B3;”Above budget”;”Below budget”)
Email : info@softexperia.com
Mobile : 6945 849400
Download excel file : sales_january_2021_a.xlsx
Δείτε τον πίνακα του αρχείου excel / View the table for excel file
| Month | Budget Sales | Actual Sales | Sales Comments | Customer | Salesperson |
|---|---|---|---|---|---|
| Jan 2021 | 1900 | 2000 | Above budget | Customer 6 | Andreas Kyriakopoulos |
| Jan 2021 | 4200 | 4000 | Below budget | Customer 5 | Andreas Kyriakopoulos |
| Jan 2021 | 3500 | 3000 | Below budget | Customer 4 | George Dimitropoulos |
| Jan 2021 | 8000 | 7000 | Below budget | Customer 3 | Trifon Papadopoulos |
| Jan 2021 | 1200 | 1500 | Above budget | Customer 2 | George Dimitropoulos |
| Jan 2021 | 800 | 1000 | Above budget | Customer 1 | Trifon Papadopoulos |
Download excel file : sales_january_2021_b.xlsx
Views: 6
Comments are closed.