register
 
 
software

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

I need help with excel.

asked by peace232 (75)

You have 50 words left!
 
 
related questions

How can I create the same excel formula for a whole column?

Can you explain the excel countif function?

How do I run an Excel formula in VBA?

How do you use the roundup function in Microsoft Excel?

What is the excel function that will count the instances of a word?

What is the formula in Excel for If then greater and lesser?

What should I do if the sum function is always zero in Excel 2003?

Tags:  how to  software

answers

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

reply
posted by Quual (161)
7 votes

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 votes

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

reply
posted by bleo (40)
7 votes

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

reply
posted by Kit (550)
6 votes

Report a post on this page as inappropriate
 If you have questions about user content, read our liability disclaimer

  
   
Add your own answer in 50 words or less! Add your comment in 50 words or less!

copyright © 2008 - 2010
conjecture corporation

FAQ About Us Contact Us Terms & Conditions Privacy Policy