Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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 | |
|
|
![]() |
||||
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 |