heattrader
New Member
- Joined
- Sep 8, 2014
- Messages
- 3
I need a formula that looks at a cell and multiplies a percentage in another cell.
For Example: If the number in cell E14 is less than or equal to 5,000,000 then multiply cell F17 (which is 55%) - This formula is in cell E17. The next formula needs to be in cell E18, If the number in cell E14 is greater than 5,000,000 then multiply cell F18 (which is 45%). So, the formulas are looking at one cell and if the number is less than or equal to 5,000,000, then multiply by 55%, if the number is greater than 5,000,000, then multiply by 45%. So, the formula has to be able to only multiply 55% up to 5,000,000 and the other formula needs to multiply by 45% over 5,000,000.
Thank for your help!
For Example: If the number in cell E14 is less than or equal to 5,000,000 then multiply cell F17 (which is 55%) - This formula is in cell E17. The next formula needs to be in cell E18, If the number in cell E14 is greater than 5,000,000 then multiply cell F18 (which is 45%). So, the formulas are looking at one cell and if the number is less than or equal to 5,000,000, then multiply by 55%, if the number is greater than 5,000,000, then multiply by 45%. So, the formula has to be able to only multiply 55% up to 5,000,000 and the other formula needs to multiply by 45% over 5,000,000.
Thank for your help!