 Related Questions

 Tags

Question by  peace232 (76)

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

I need help with excel.

 +1 vote! +7 you voted 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

 +1 vote! +7 you voted 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.

 +1 vote! +7 you voted 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.

 +1 vote! +6 you voted 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