Need Help with an IF function
I'm trying to work out a calculation where I'm trying to use the IF function to auto calculate a result.
Here is my formula:
What I'm trying to accomplish is calculate a percentage dollar amount (40%) and then add those amounts until the SUM of the column hits $18000. This means that the amount calculated that hits $18000 will be less than 18000. After the SUM hits $18000 rather then calculate the percentage it should enter $100 into the cell.
I know this should be something I can do it just has me stumped.
SUM Function in Excel!
Hello! I Think it would be easier for you if you use SUM Functions in Excel Particularly SUMIFS, that formula is a bit too complicated in terms of having an IF function inside another IF Function. This saves a lot of time and thinking.
Hope this helps!
|All times are GMT +1. The time now is 04:36 PM.|
Powered by vBulletin® Copyright ©2000 - 2022, Jelsoft Enterprises Ltd.