variable value

[darman]

Hello.
I need the v (variable) in the following formula example B1=(v-A1) to get different values defined by me.
The same formula will be applied to B2=(v-A2), B3=(v-A3),... up to B10=(v-A10).
V will have max 1 decimal place and will range from 0.1 up to 99.9
Can somebody please explain how to do this?

Further, I need the positive or negative sign to display after formula execution.
Example: A1=24 and v=23.7 B1=(23.7-24)=-0.3 or A2=15.5 and v=16.5 B2=(16.5-15.5)=+1


Please help considering I don't know how to do much more than add,subtract,multiply or divide in Excel.
Thank you

[shg]

Select the cell you wish to have the value v. In the Names box (left of the formula bar, enter "v" (sans quotes).

In B1 and copy down, =v-A1

Format column B as +General;-General;0

[darman]

thanks shg. But where and how should i input values that v needs to acquire?

[VBA Noob]

Your post does not comply with Rule 8 of our Forum RULES. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser)to the cross-post. Expect cross-posts without a link to be closed a message will be posted by the moderator explaining why. We are here to help so help us help you!

[darman]

Sorry for missing the rule. Here is the link to same post in other forum:
http://www.mrexcel.com/forum/showthread.php?t=380767

[shg]

You put the value of v in the cell you named in the first step.

[darman]

Tried the format you suggested shg and it works great. Just what I need, nice and simple.
However I don't understand what you mean on how to put the value of V, probably because I did not explained it right. v value is a variable and so will change in B1, B2, B3 up to B10. Maybe I should name my v as v1, v2, v3,...up to v10.
What I did not mention is that I intend to dictate with speech recognition the v1, v2, v3... values.
What I don't know is how my v1...v10 variables in column B will GET or acquire the values dictated. To make it simpler we can consider input to be typed. I will worry about the dictated input later.

I imagine I must make a corresponding range of cells in another area of the worksheet that will "link" the dictated input values to the v's in my B column.
If this is the way than a separate worksheet for input and link those values to the 1st worksheet with the formulas would be better because I described a simple example of my needs. In fact 1 full A4 worksheet will be used with different columns and same transposed formula.

Unless there is a better way to dictate directly values to the v's in the formulas.
darman

[shg]

Then put the v values in column C and change the formula in B1 to =C1-A1