Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Help needed
Hello there, I need some help figuring out the correct formula...What I
am doing is adding the number of parts done by a particular person and when this total reaches 35, I would like to show in another column, how many over 35 he/she has done as a incentive will be paid on this number over 35..I was able to get the simple part - the adding up to 35 done but have gotten no further.....any help will be greatly appreciated.....Mike |
#2
|
|||
|
|||
Mike, see if something like this will work =IF(A135,A1-35,"")
-- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Mike Kasiorek" wrote in message ... Hello there, I need some help figuring out the correct formula...What I am doing is adding the number of parts done by a particular person and when this total reaches 35, I would like to show in another column, how many over 35 he/she has done as a incentive will be paid on this number over 35..I was able to get the simple part - the adding up to 35 done but have gotten no further.....any help will be greatly appreciated.....Mike |
#3
|
|||
|
|||
Hi
try =MAX(0,35-SUM_Formula) -- Regards Frank Kabel Frankfurt, Germany "Mike Kasiorek" schrieb im Newsbeitrag ... Hello there, I need some help figuring out the correct formula...What I am doing is adding the number of parts done by a particular person and when this total reaches 35, I would like to show in another column, how many over 35 he/she has done as a incentive will be paid on this number over 35..I was able to get the simple part - the adding up to 35 done but have gotten no further.....any help will be greatly appreciated.....Mike |
#4
|
|||
|
|||
Hi
Alhough you have first formula, here is my example for this too: Amount1=MIN(35,SUMIF(ConditionRange,Condition,SumR ange)) The formula you asked for: Amount2=SUMIF(ConditionRange,Condition,SumRange)-Amount1 (Instead Amount1 insert the reference to cell with first forlmula) -- Arvi Laanemets (When sending e-mail, use address arvil<Attarkon.ee) "Mike Kasiorek" wrote in message ... Hello there, I need some help figuring out the correct formula...What I am doing is adding the number of parts done by a particular person and when this total reaches 35, I would like to show in another column, how many over 35 he/she has done as a incentive will be paid on this number over 35..I was able to get the simple part - the adding up to 35 done but have gotten no further.....any help will be greatly appreciated.....Mike |
#5
|
|||
|
|||
Thanks you all, finally got it figured out and looks good....
Mike Kasiorek wrote: Hello there, I need some help figuring out the correct formula...What I am doing is adding the number of parts done by a particular person and when this total reaches 35, I would like to show in another column, how many over 35 he/she has done as a incentive will be paid on this number over 35..I was able to get the simple part - the adding up to 35 done but have gotten no further.....any help will be greatly appreciated.....Mike |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mail Merging Help Needed. Quickly! | Excel Discussion (Misc queries) | |||
Drop down list or combo box help needed | Excel Discussion (Misc queries) | |||
Formula needed | Excel Worksheet Functions | |||
Help Needed With - If-Function | Excel Worksheet Functions | |||
Tricky formulas needed | Excel Worksheet Functions |