| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need reference for max and [#this row] function
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Need reference for max and [#this row] function
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" wrote: 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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Need reference for max and [#this row] function
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" wrote: 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" wrote: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| large function result as reference for offset function | Excel Discussion (Misc queries) | |||
| Reference function name from a different cell | Excel Discussion (Misc queries) | |||
| 3D function with dynamic reference | Excel Worksheet Functions | |||
| reference a function | Excel Worksheet Functions | |||
| Cell Reference in Function | Excel Worksheet Functions | |||
Linear Mode
