Need reference for max and [#this row] function

S

SCC

I have a spreadsheet where I use the function =MAX(Table1[[#This Row],[12:30
PM]]-1,0). I can't remember where I found the information to create this
formula but I think it was from the Microsoft site.
 
S

Shane Devenshire

Hi,

Why not use regular references. However, I'm not sure what your questin is
- do you want to know where you found this example?
 
S

SCC

I don't remember where I found this example. When I look up max function it
gives no information about the -1,0 option. I would like to learn more so I
can create my own functions.

Shane Devenshire said:
Hi,

Why not use regular references. However, I'm not sure what your questin is
- do you want to know where you found this example?

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


SCC said:
I have a spreadsheet where I use the function =MAX(Table1[[#This Row],[12:30
PM]]-1,0). I can't remember where I found the information to create this
formula but I think it was from the Microsoft site.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top