software






 

Question by  peace232 (76)

What is the formula in excel for result of function as a value?

I need help with excel.

 
+7

Answer by  Quual (161)

A custom function that takes the value passed to it and returns it * 3 + 5 Function times3plus5(value) Dim val As Long val = CLng(value) times3plus5 = val * 3 + 5 End Function if we put the formula =times3plus5(5) in a cell, excel converts it to 20

 
+7

Answer by  markochiguegmailcom (514)

There is an Excel text function called Value(text) that converts its text parameter that represents a number (i. e. "12345" or a cell reference that contains such text data) to its corresponding number value. To use this function, simply enter this sample in the formula bar: =Value("67890"). You will get the number value 67890.

 
+7

Answer by  bleo (41)

Try wrapping your formulation or function around the TEXT() formula. Example: =TEXT(Formula,"0"). See Excel help for infomation on this function.

 
+6

Answer by  Kit (558)

A formula is an expression used to carry out an operation. A function is a built-in Excel formala, like =sum(B4:B10), =min(B4:B10)...those are functions in Excel

 
You have 50 words left!