Need different formula in table cells

[SCC]

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

 

[Shane Devenshire]

Hi,

One solution is to use regular cell reference and avoid the structured table
references.

 

[SCC]

Shane,

How would I do this. I can't remember how I got the original formula.

Linda

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

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