| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Return value for a function.
Hi,
My function returns an integer and I want it to return the double value. Sub testFunction() dim x7 as double x7 = 6543.54384 X3 = MaxValue(55, x7) 'but X3 = 6544 not 6543.54384 like I want Function MaxValue(a, b) If a < b Then MaxValue = b Else MaxValue = a End If End Function |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Return value for a function.
Whoops, I forgot X3 was an integer. Just ignore this post, sorry!
"Jeff" wrote: Hi, My function returns an integer and I want it to return the double value. Sub testFunction() dim x7 as double x7 = 6543.54384 X3 = MaxValue(55, x7) 'but X3 = 6544 not 6543.54384 like I want Function MaxValue(a, b) If a < b Then MaxValue = b Else MaxValue = a End If End Function |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If function returns #REF!, want it to return 0 | Excel Worksheet Functions | |||
| Why does this function NOT return a value? | Excel Discussion (Misc queries) | |||
| Only do Sum function if not "0", IF"0" then return "0" | Excel Worksheet Functions | |||
| Function to return value from each tab | Excel Worksheet Functions | |||
| Function to look at two cells and return a third | Excel Worksheet Functions | |||
Linear Mode
