That Excel Guy
New Member
- Joined
- Apr 1, 2008
- Messages
- 9
Hi Folks - need your help here. I am building a localization report that calculates the percentage of consumption.
Problem is that either one of the values to be caluculated may be larger than the other.
Here's an example - we have 357 folks engaged in Chinese training, but only 33 in English.
However, the next formula down has German enagement, and the traditional formula has flipped - there are 66 folks enaged in German training, but there are 125 in English.
Is there a formula that can be written as a "catch all" that can be dragged down to fill all of the languages, but account for variables on either side?
Problem is that either one of the values to be caluculated may be larger than the other.
Here's an example - we have 357 folks engaged in Chinese training, but only 33 in English.
However, the next formula down has German enagement, and the traditional formula has flipped - there are 66 folks enaged in German training, but there are 125 in English.
Is there a formula that can be written as a "catch all" that can be dragged down to fill all of the languages, but account for variables on either side?
