Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
can a function do this?
Hi
In this function, i would like the cell to look at the current year and month. if this is the current month and year, eg may2006, if true, add up a list of names, if false eg mar 2006, keep the total that was counted when true. so the funtion needs to save the number counted when true and then keep it for when the junction is false. i have tried to do this without success. can anyone help? thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
can a function do this?
No, you would need multiple cells for that as a cell cannot have a value and
a formula, one or the other, not both. -- HTH Bob Phillips (remove xxx from email address if mailing direct) "jamie" wrote in message ... Hi In this function, i would like the cell to look at the current year and month. if this is the current month and year, eg may2006, if true, add up a list of names, if false eg mar 2006, keep the total that was counted when true. so the funtion needs to save the number counted when true and then keep it for when the junction is false. i have tried to do this without success. can anyone help? thanks |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
can a function do this?
thanks. but isnt that classed as circular?
eg. cell a1 has the function, the true total is saved to b1, then a1 = b2 if the a1 statement is false... "Bob Phillips" wrote: No, you would need multiple cells for that as a cell cannot have a value and a formula, one or the other, not both. -- HTH Bob Phillips (remove xxx from email address if mailing direct) "jamie" wrote in message ... Hi In this function, i would like the cell to look at the current year and month. if this is the current month and year, eg may2006, if true, add up a list of names, if false eg mar 2006, keep the total that was counted when true. so the funtion needs to save the number counted when true and then keep it for when the junction is false. i have tried to do this without success. can anyone help? thanks |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
can a function do this?
I don't think I fully understand what you are trying to do. Keep an example
of TRUE and an example of FALSE. -- HTH Bob Phillips (remove xxx from email address if mailing direct) "jamie" wrote in message ... thanks. but isnt that classed as circular? eg. cell a1 has the function, the true total is saved to b1, then a1 = b2 if the a1 statement is false... "Bob Phillips" wrote: No, you would need multiple cells for that as a cell cannot have a value and a formula, one or the other, not both. -- HTH Bob Phillips (remove xxx from email address if mailing direct) "jamie" wrote in message ... Hi In this function, i would like the cell to look at the current year and month. if this is the current month and year, eg may2006, if true, add up a list of names, if false eg mar 2006, keep the total that was counted when true. so the funtion needs to save the number counted when true and then keep it for when the junction is false. i have tried to do this without success. can anyone help? thanks |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
can a function do this?
i am aware each function has a true and false. what do you mean?
"Bob Phillips" wrote: I don't think I fully understand what you are trying to do. Keep an example of TRUE and an example of FALSE. -- HTH Bob Phillips (remove xxx from email address if mailing direct) "jamie" wrote in message ... thanks. but isnt that classed as circular? eg. cell a1 has the function, the true total is saved to b1, then a1 = b2 if the a1 statement is false... "Bob Phillips" wrote: No, you would need multiple cells for that as a cell cannot have a value and a formula, one or the other, not both. -- HTH Bob Phillips (remove xxx from email address if mailing direct) "jamie" wrote in message ... Hi In this function, i would like the cell to look at the current year and month. if this is the current month and year, eg may2006, if true, add up a list of names, if false eg mar 2006, keep the total that was counted when true. so the funtion needs to save the number counted when true and then keep it for when the junction is false. i have tried to do this without success. can anyone help? thanks |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
can a function do this?
I mean give an example where it does equal current month and year with
required results, and then one where it doesn't. -- HTH Bob Phillips (remove xxx from email address if mailing direct) "jamie" wrote in message ... i am aware each function has a true and false. what do you mean? "Bob Phillips" wrote: I don't think I fully understand what you are trying to do. Keep an example of TRUE and an example of FALSE. -- HTH Bob Phillips (remove xxx from email address if mailing direct) "jamie" wrote in message ... thanks. but isnt that classed as circular? eg. cell a1 has the function, the true total is saved to b1, then a1 = b2 if the a1 statement is false... "Bob Phillips" wrote: No, you would need multiple cells for that as a cell cannot have a value and a formula, one or the other, not both. -- HTH Bob Phillips (remove xxx from email address if mailing direct) "jamie" wrote in message ... Hi In this function, i would like the cell to look at the current year and month. if this is the current month and year, eg may2006, if true, add up a list of names, if false eg mar 2006, keep the total that was counted when true. so the funtion needs to save the number counted when true and then keep it for when the junction is false. i have tried to do this without success. can anyone help? thanks |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
can a function do this?
Are you saying that you want the formula to show April 2006 until May is
reached and then show May? -- Don Guillett SalesAid Software "jamie" wrote in message ... Hi In this function, i would like the cell to look at the current year and month. if this is the current month and year, eg may2006, if true, add up a list of names, if false eg mar 2006, keep the total that was counted when true. so the funtion needs to save the number counted when true and then keep it for when the junction is false. i have tried to do this without success. can anyone help? thanks |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
can a function do this?
no, i mean each month has a serparate cell. when the next month starts, then
the following cell will count up how many names in the list and the previous month, that cell will keep the amount it had when true. "Don Guillett" wrote: Are you saying that you want the formula to show April 2006 until May is reached and then show May? -- Don Guillett SalesAid Software "jamie" wrote in message ... Hi In this function, i would like the cell to look at the current year and month. if this is the current month and year, eg may2006, if true, add up a list of names, if false eg mar 2006, keep the total that was counted when true. so the funtion needs to save the number counted when true and then keep it for when the junction is false. i have tried to do this without success. can anyone help? thanks |
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
can a function do this?
the below is for one of the periods of time. under number of people at the
moment is just example data. 2006 Month Month No. of people January 1 10 February 2 10 March 3 7 April 4 7 May 5 9 June 6 July 7 August 8 September 9 October 10 November 11 December 12 "Don Guillett" wrote: copy/paste your layout here -- Don Guillett SalesAid Software "jamie" wrote in message ... no, i mean each month has a serparate cell. when the next month starts, then the following cell will count up how many names in the list and the previous month, that cell will keep the amount it had when true. "Don Guillett" wrote: Are you saying that you want the formula to show April 2006 until May is reached and then show May? -- Don Guillett SalesAid Software "jamie" wrote in message ... Hi In this function, i would like the cell to look at the current year and month. if this is the current month and year, eg may2006, if true, add up a list of names, if false eg mar 2006, keep the total that was counted when true. so the funtion needs to save the number counted when true and then keep it for when the junction is false. i have tried to do this without success. can anyone help? thanks |
#11
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
can a function do this?
I still don't understand what answer you want. Give a complete example of
the desired result. -- Don Guillett SalesAid Software "jamie" wrote in message ... the below is for one of the periods of time. under number of people at the moment is just example data. 2006 Month Month No. of people January 1 10 February 2 10 March 3 7 April 4 7 May 5 9 June 6 July 7 August 8 September 9 October 10 November 11 December 12 "Don Guillett" wrote: copy/paste your layout here -- Don Guillett SalesAid Software "jamie" wrote in message ... no, i mean each month has a serparate cell. when the next month starts, then the following cell will count up how many names in the list and the previous month, that cell will keep the amount it had when true. "Don Guillett" wrote: Are you saying that you want the formula to show April 2006 until May is reached and then show May? -- Don Guillett SalesAid Software "jamie" wrote in message ... Hi In this function, i would like the cell to look at the current year and month. if this is the current month and year, eg may2006, if true, add up a list of names, if false eg mar 2006, keep the total that was counted when true. so the funtion needs to save the number counted when true and then keep it for when the junction is false. i have tried to do this without success. can anyone help? thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating a Custom Excel Function to Calculate Gini Coefficients | Excel Worksheet Functions | |||
Date & Time | New Users to Excel | |||
Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions |