Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Automatically add and subtract
Hello all,
I had such great success with my last question that I am going to attempt one last question which will save me plenty of headaches if answered. I have designed a monthly tracking program that each employee enters the number of work they complete in a month. We will call this an €˜activity report. In the activity report, there is a monthly roll-up sheet that totals all the work completed in that month (31 days) using numbers. I have created a €˜base program that lists all employees at the top with the same headings used in the monthly roll-up. To eliminate the need for key punching the employees numbers attained each month, I have placed links from the base program under each employees name along side the headings. The base program is in a folder. Each month, the employees complete the number of each work type and punch that number in the appropriate cell along side each heading. The monthly roll-up page automatically totals the work for the month using sum formulas. The employee sends this electronic activity report to their respective supervisors and said reports are dragged into the folder containing the base program. When the base program is opened, the links ask me to update the totals which it does. Question: Is there a formula that will do the following; o If the number in a cell in the €˜activity report is 0 (zero) , leave it as 0 o If the €˜activity report cell has a number greater than 0, add it to the base in that cell o If the €˜activity report cell has a number less than the number in the base, subtract it from the number currently in the base. Thank you. -Bad |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Automatically add and subtract
from what you have described, generally, the IF function will do what you want.
to get the desire result you are after, a sample and expected result is necessary. -- Hope this is helpful Pls click the Yes button below if this post provide answer you have asked Thank You cheers, francis Am not a greek but an ordinary user trying to assist another "BadBoy" wrote: Hello all, I had such great success with my last question that I am going to attempt one last question which will save me plenty of headaches if answered. I have designed a monthly tracking program that each employee enters the number of work they complete in a month. We will call this an €˜activity report. In the activity report, there is a monthly roll-up sheet that totals all the work completed in that month (31 days) using numbers. I have created a €˜base program that lists all employees at the top with the same headings used in the monthly roll-up. To eliminate the need for key punching the employees numbers attained each month, I have placed links from the base program under each employees name along side the headings. The base program is in a folder. Each month, the employees complete the number of each work type and punch that number in the appropriate cell along side each heading. The monthly roll-up page automatically totals the work for the month using sum formulas. The employee sends this electronic activity report to their respective supervisors and said reports are dragged into the folder containing the base program. When the base program is opened, the links ask me to update the totals which it does. Question: Is there a formula that will do the following; o If the number in a cell in the €˜activity report is 0 (zero) , leave it as 0 o If the €˜activity report cell has a number greater than 0, add it to the base in that cell o If the €˜activity report cell has a number less than the number in the base, subtract it from the number currently in the base. Thank you. -Bad |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Automatically add and subtract
Example:
Book 1 Monthly Totals page Cell A1 has the number 5 typed in it. Book 2 Yearly Totals page Cell A1 has a 0 in it =SUM('[Book1.xls]Monthly Totals'!$A$1) In the above formula, book 2 will automatically add 5 to 0 I wish to have the above formula add what ever number is in cell A1 of book 1 to Cell A1 of book 2 and as well, if the number in book 1 is less than that of book 2, subtract it or if equal, leave it as it is. "Francis" wrote: from what you have described, generally, the IF function will do what you want. to get the desire result you are after, a sample and expected result is necessary. -- Hope this is helpful Pls click the Yes button below if this post provide answer you have asked Thank You cheers, francis Am not a greek but an ordinary user trying to assist another "BadBoy" wrote: Hello all, I had such great success with my last question that I am going to attempt one last question which will save me plenty of headaches if answered. I have designed a monthly tracking program that each employee enters the number of work they complete in a month. We will call this an €˜activity report. In the activity report, there is a monthly roll-up sheet that totals all the work completed in that month (31 days) using numbers. I have created a €˜base program that lists all employees at the top with the same headings used in the monthly roll-up. To eliminate the need for key punching the employees numbers attained each month, I have placed links from the base program under each employees name along side the headings. The base program is in a folder. Each month, the employees complete the number of each work type and punch that number in the appropriate cell along side each heading. The monthly roll-up page automatically totals the work for the month using sum formulas. The employee sends this electronic activity report to their respective supervisors and said reports are dragged into the folder containing the base program. When the base program is opened, the links ask me to update the totals which it does. Question: Is there a formula that will do the following; o If the number in a cell in the €˜activity report is 0 (zero) , leave it as 0 o If the €˜activity report cell has a number greater than 0, add it to the base in that cell o If the €˜activity report cell has a number less than the number in the base, subtract it from the number currently in the base. Thank you. -Bad |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Automatically add and subtract
Example:
Book 1 Monthly Totals page Cell A1 has the number 5 typed in it. Book 2 Yearly Totals page Cell A1 has a 0 in it =SUM('[Book1.xls]Monthly Totals'!$A$1) In the above formula, book 2 will automatically add 5 to 0 I wish to have the above formula add what ever number is in cell A1 of book 1 to Cell A1 of book 2 and as well, if the number in book 1 is less than that of book 2, subtract it or if equal, leave it as it is. PS. Can a moderator delete the other post by the same name please. "Francis" wrote: from what you have described, generally, the IF function will do what you want. to get the desire result you are after, a sample and expected result is necessary. -- Hope this is helpful Pls click the Yes button below if this post provide answer you have asked Thank You cheers, francis Am not a greek but an ordinary user trying to assist another "BadBoy" wrote: Hello all, I had such great success with my last question that I am going to attempt one last question which will save me plenty of headaches if answered. I have designed a monthly tracking program that each employee enters the number of work they complete in a month. We will call this an €˜activity report. In the activity report, there is a monthly roll-up sheet that totals all the work completed in that month (31 days) using numbers. I have created a €˜base program that lists all employees at the top with the same headings used in the monthly roll-up. To eliminate the need for key punching the employees numbers attained each month, I have placed links from the base program under each employees name along side the headings. The base program is in a folder. Each month, the employees complete the number of each work type and punch that number in the appropriate cell along side each heading. The monthly roll-up page automatically totals the work for the month using sum formulas. The employee sends this electronic activity report to their respective supervisors and said reports are dragged into the folder containing the base program. When the base program is opened, the links ask me to update the totals which it does. Question: Is there a formula that will do the following; o If the number in a cell in the €˜activity report is 0 (zero) , leave it as 0 o If the €˜activity report cell has a number greater than 0, add it to the base in that cell o If the €˜activity report cell has a number less than the number in the base, subtract it from the number currently in the base. Thank you. -Bad |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do i subtract 3 hrs from now()? | Excel Worksheet Functions | |||
subtract | Excel Worksheet Functions | |||
subtract the value by setting up automatically | Excel Discussion (Misc queries) | |||
how to subtract one row from the other? | Excel Discussion (Misc queries) | |||
Add IF or Subtract IF?? | Excel Worksheet Functions |