Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If statement with generic value
I have a spreadsheet for recording Board members' payments. All 4 quarters
are on one sheet with with subtotals after each quarter (cells C13, C18, C23 & C28) and a "Total Due This Quarter" in cell C31. What I want to happen in C31 is only give the total for the current quarter. Is there a way to do that even when I don't have a specific value in the subtotal cells? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If statement with generic value
Maybe this:
=CHOOSE(CEILING(MONTH(NOW())/3,1),C13,C18,C23,C28) -- Biff Microsoft Excel MVP "Blessedx3" wrote in message ... I have a spreadsheet for recording Board members' payments. All 4 quarters are on one sheet with with subtotals after each quarter (cells C13, C18, C23 & C28) and a "Total Due This Quarter" in cell C31. What I want to happen in C31 is only give the total for the current quarter. Is there a way to do that even when I don't have a specific value in the subtotal cells? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If statement with generic value
That won't work. I don't have a specific month listed, just the total for
the quarter - "Total First Quarter" in C13, "Total Second Quarter" in C18, etc. "T. Valko" wrote: Maybe this: =CHOOSE(CEILING(MONTH(NOW())/3,1),C13,C18,C23,C28) -- Biff Microsoft Excel MVP "Blessedx3" wrote in message ... I have a spreadsheet for recording Board members' payments. All 4 quarters are on one sheet with with subtotals after each quarter (cells C13, C18, C23 & C28) and a "Total Due This Quarter" in cell C31. What I want to happen in C31 is only give the total for the current quarter. Is there a way to do that even when I don't have a specific value in the subtotal cells? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If statement with generic value
"T. Valko" wrote...
Maybe this: =CHOOSE(CEILING(MONTH(NOW())/3,1),C13,C18,C23,C28) .... Save a function call CEILING(MONTH(NOW())/3,1) - (MONTH(NOW())+2)/3 since CHOOSE truncates its 1st argument to integers. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If statement with generic value
Did you try the code before ruling it out? The CEILING(MONTH(NOW())/3,1)
part of the formula returns the current quarter and has nothing to do with months on your worksheet. -- Rick (MVP - Excel) "Blessedx3" wrote in message ... That won't work. I don't have a specific month listed, just the total for the quarter - "Total First Quarter" in C13, "Total Second Quarter" in C18, etc. "T. Valko" wrote: Maybe this: =CHOOSE(CEILING(MONTH(NOW())/3,1),C13,C18,C23,C28) -- Biff Microsoft Excel MVP "Blessedx3" wrote in message ... I have a spreadsheet for recording Board members' payments. All 4 quarters are on one sheet with with subtotals after each quarter (cells C13, C18, C23 & C28) and a "Total Due This Quarter" in cell C31. What I want to happen in C31 is only give the total for the current quarter. Is there a way to do that even when I don't have a specific value in the subtotal cells? |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If statement with generic value
That calculates the (calendar) quarter number based on TODAY'S date and
returns the value from one of 4 cells based on the quarter number. If that isn't what you wanted then I don't understand. -- Biff Microsoft Excel MVP "Blessedx3" wrote in message ... That won't work. I don't have a specific month listed, just the total for the quarter - "Total First Quarter" in C13, "Total Second Quarter" in C18, etc. "T. Valko" wrote: Maybe this: =CHOOSE(CEILING(MONTH(NOW())/3,1),C13,C18,C23,C28) -- Biff Microsoft Excel MVP "Blessedx3" wrote in message ... I have a spreadsheet for recording Board members' payments. All 4 quarters are on one sheet with with subtotals after each quarter (cells C13, C18, C23 & C28) and a "Total Due This Quarter" in cell C31. What I want to happen in C31 is only give the total for the current quarter. Is there a way to do that even when I don't have a specific value in the subtotal cells? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Generic Macro that can rows of zeroes | Excel Discussion (Misc queries) | |||
Generic Worksheet Names | Excel Discussion (Misc queries) | |||
Generic reference in a Macro | Excel Discussion (Misc queries) | |||
HOW TO RETRIVE LAST NAME USING EXCEL, IT SHOULD BE GENERIC | Excel Worksheet Functions | |||
Creation of a Generic Macro | Excel Worksheet Functions |