value formula

Hey, guys. Thanks for stopping. I was hoping someone could tell me what I need to do to fix this formula so that it pulls the VALUE portions in a 3 decimal format. Fields G9,D10, and J24 will all have percentages in them in three decimal places. When I'm CONCATENATE-ing, I'd like the value from...

a column contains 'amount'. The amount can be from 1-999999. Some cells also contains #N/A (thr' formula) & blank (thr' formula). I want to get NUMBERS of 'amount' whose value is 1-10000 10001-20000 20001-30000 30001-40000 40001-50000 50001 and above.

In A2, I want A if there is a value in A1 else B.

L9 & R9 contains either "" (null) or values. In S9, I want to get L9 or R9 whichever contains value.

I have a userform that shows the results of many values in 20 text strings such as: textlabel1= "firstname1 & " " & lastname1 & " " & housenumber1 & " " & street name1" textlabel2= "firstname2 & " " & lastname2 & " " & housenumber2 & " " & street name2" I want to set the text lengths of ...

Hi, I have searched and seached the forum but cant find the answer to this most basic question. I have a line of code which puts a formula into cell A1. All I want to do is have the code do the formula and the result only show in cell A1. Here's an example of the code: Range("A1").Formula...

A2 contains a forumula that returns a value of 12345. of course when you select on A2 it shows the forumula that creates that value. in b2 I want to add a formula that looks at the final value of A2 (12345) looks for it on a list of values in column c if result is N/A (bc value is not on C) -...