| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need different formula in table cells
I have the following table that uses the formula =MAX(Table1[[#This
Row],[1:30]]-1,0). Mon 8:30 9:30 10:30 etc... Tue Wed Th Fri Sat repeat row headings Monday -Thursday I need to subtract 1 from the related cell in Table 1. Friday and Saturday I do not. When I edit the cell formula for a Friday row it changes the formula for all the cells in that column. Is there a way around this or do I need to create seperate tables. Thanks, Linda |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Need different formula in table cells
Hi,
One solution is to use regular cell reference and avoid the structured table references. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "SCC" wrote: I have the following table that uses the formula =MAX(Table1[[#This Row],[1:30]]-1,0). Mon 8:30 9:30 10:30 etc... Tue Wed Th Fri Sat repeat row headings Monday -Thursday I need to subtract 1 from the related cell in Table 1. Friday and Saturday I do not. When I edit the cell formula for a Friday row it changes the formula for all the cells in that column. Is there a way around this or do I need to create seperate tables. Thanks, Linda |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Need different formula in table cells
Shane,
How would I do this. I can't remember how I got the original formula. Linda "Shane Devenshire" wrote: Hi, One solution is to use regular cell reference and avoid the structured table references. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "SCC" wrote: I have the following table that uses the formula =MAX(Table1[[#This Row],[1:30]]-1,0). Mon 8:30 9:30 10:30 etc... Tue Wed Th Fri Sat repeat row headings Monday -Thursday I need to subtract 1 from the related cell in Table 1. Friday and Saturday I do not. When I edit the cell formula for a Friday row it changes the formula for all the cells in that column. Is there a way around this or do I need to create seperate tables. Thanks, Linda |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| changing table cells colours using a master table | Excel Discussion (Misc queries) | |||
| Using 2 cells in a table to retrieve data from another table | Excel Worksheet Functions | |||
| formula for selecting cells in one table from values in another | Excel Worksheet Functions | |||
| Pivot Table Counta formula and sum for unhidden cells only | Excel Discussion (Misc queries) | |||
| Can I connect Excel cells to cells in an embedded Word table? | Excel Discussion (Misc queries) | |||
Linear Mode
