sjbutler69
New Member
- Joined
- Sep 3, 2014
- Messages
- 4
Need a formula for IF SUM
If the sum of A14:A20 is less than 4,741,852 than multiply A20 by B6
If the sum of A14:A20 is greater than or equal to 4,741,852 than multiply A20 by B7
If the sum of A14:A20 is greater than or equal to 7,000,000 than multiply A20 by B8
If the sum of A14:A20 is less than 4,741,852 than multiply A20 by B6
If the sum of A14:A20 is greater than or equal to 4,741,852 than multiply A20 by B7
If the sum of A14:A20 is greater than or equal to 7,000,000 than multiply A20 by B8