#### paul29berks

##### Active Member

- Joined
- Mar 15, 2004

- Messages
- 293

For Example

2004 Actual Results

Germany Class1

Total Class 1

Dealer 1 - Product A = 0 Product B = 1 1

Dealer 2 - Product A = 0 Product B = 2 2

Dealer 3 - Product A = 0 Product B = 3 3

2005 Plan

Germany

Class 1

Total Product A = 1 Product B = 6

so for Dealer 1 and Product B in Germany

= Germany Class 1 2004 Actual results dealer 1 Product B/Total Product B * Total Product B 2005 = 1

For Product A I have 0 for 2004 and total for 2005 of 1 -Can I write a formula which states:

if 2004 Actual results Germay dealer 1 Product A/total product A * Total Product A 2005 = 0 then calculate total for class 1 dealer (i.e Product A + Product B)/total class 1 2004 * product A 2005?

Many Thanks