Need different formula in table cells

  • Thread starter Thread starter SCC
  • Start date Start date
S

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
 
Hi,

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

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

Linda

Shane Devenshire said:
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 said:
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
Click to expand...
Click to expand...
 
Back
Top