mrkris1982
Active Member
- Joined
- Apr 16, 2009
- Messages
- 407
Step 1: E, F and G may or may not have an X in the column. When there is an X, i want to total the number of X's in that row, in column H
Step 2: I has a $ amount. J, K and L have names for headers. I want the value to be the following:
For column J: If X is in column E, then divide I by H and multiply by .65
For column K: If X is in column F, then divide I by H and multiply by .35
For column L: If X is in column G, then divide I by H and multiply by .35
If possible, would prefer to have all cells remain empty/blank until there's data to be calculated.
Whats the easiest way to accomplish this?
TIA
Step 2: I has a $ amount. J, K and L have names for headers. I want the value to be the following:
For column J: If X is in column E, then divide I by H and multiply by .65
For column K: If X is in column F, then divide I by H and multiply by .35
For column L: If X is in column G, then divide I by H and multiply by .35
If possible, would prefer to have all cells remain empty/blank until there's data to be calculated.
Whats the easiest way to accomplish this?
TIA
Last edited: