LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old September 11th 18, 04:37 PM
Junior Member
First recorded activity by ExcelBanter: Sep 2018
Posts: 2
Default 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:
=IF((D10*40%)+SUM(F$2:F9)<=18000,+D10*40%,IF((D10* 40%)+SUM(F$2:F9)=18000,+J$2-SUM(F$2:F9),100))

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.


  #2   Report Post  
Old July 15th 21, 06:31 PM
First recorded activity by ExcelBanter: Jun 2021
Posts: 47
Default 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!

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
User Function Question: Collect Condition in Dialog Box - But How toInsert into Function Equation? SteveM Excel Programming 1 January 3rd 08 03:45 PM
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) [email protected] Excel Worksheet Functions 0 September 5th 06 03:44 PM
Excel - User Defined Function Error: This function takes no argume BruceInCalgary Excel Programming 3 August 23rd 06 08:53 PM
A correct IF function doesn't show the function's result in cell Michael Excel Discussion (Misc queries) 1 April 10th 06 09:10 AM
Adding a custom function to the default excel function list DonutDel Excel Programming 3 November 21st 03 03:41 PM

All times are GMT +1. The time now is 01:03 PM.

Powered by vBulletin® Copyright ©2000 - 2022, Jelsoft Enterprises Ltd.
Copyright 2004-2022 ExcelBanter.
The comments are property of their posters.

About Us

"It's about Microsoft Excel"


Copyright © 2017