Need Help Please with Excel Formula

[Lindee]

I am new to Excel and I'm trying to write a formula that will change the value of a set of numbers to a different value. i.e. 116 ~161~ 161 i.e. 225~ 552~525~ 520 for numbers 1 thru 0.
Would some kind soul Help me. I have started writing with the Subsitute function however I'm not advanced enough to go beyond the 1st 2 conversions.
Thanks in Advance.
Lindee

 

[Lindee]

<colgroup><col style="mso-width-source:userset;mso-width-alt:3364;width:138pt" width="184"> <col style="mso-width-source:userset;mso-width-alt:5741;width:236pt" width="314"> <col style="mso-width-source:userset;mso-width-alt:8594;width:353pt" width="470"> <col style="width:191pt" width="254"> </colgroup><tbody>
[TD="class: xl72, width: 184"]Same results. Tried in 2 empty cells.

=ISNUMBER(A2)



[/TD]
[TD="class: xl67, width: 314"]A[/TD]
[TD="class: xl67, width: 470"]B[/TD]
[TD="class: xl71, width: 254"]=ISNUMBER(A2)[/TD]

[TD="class: xl67, width: 184"]1[/TD]
[TD="class: xl68, width: 314"]Original[/TD]
[TD="class: xl68, width: 470"]Converted[/TD]
[TD="class: xl65"][/TD]

[TD="class: xl67, width: 184"]2[/TD]
[TD="class: xl69, width: 314"]116[/TD]
[TD="class: xl70"]=SUMPRODUCT(MOD(MID(A2,{1;2;3},1)+5,10)*{100;10;1})[/TD]
[TD="class: xl65"][/TD]

[TD="class: xl67, width: 184"]3[/TD]
[TD="class: xl69, width: 314"]787[/TD]
[TD="class: xl69, width: 470"]232[/TD]
[TD="class: xl65"][/TD]

[TD="class: xl67, width: 184"]4[/TD]
[TD="class: xl69, width: 314"]234[/TD]
[TD="class: xl69, width: 470"]789[/TD]
[TD="class: xl65"][/TD]

[TD="class: xl67, width: 184"]5[/TD]
[TD="class: xl69, width: 314"]278[/TD]
[TD="class: xl69, width: 470"]723[/TD]
[TD="class: xl65"][/TD]

[TD="class: xl67, width: 184"]6[/TD]
[TD="class: xl69, width: 314"]109[/TD]
[TD="class: xl69, width: 470"]654[/TD]
[TD="class: xl65"][/TD]

</tbody>

 

[Marcelo Branco]

What do you mean by "same results"?
Are you saying that you cannot insert in a cell a very simple formula as =ISNUMBER(A2)? Is so, your Excel has problems.
By the way, what Excel version are you using?

M.

 

[Lindee]

I mean it is not working when I place the = ISNUMBER command in an empty cell. I have suspected that Excel is not working correctly, so I have Excel 10 on the way.. I have Microsoft Home and Student 2007 version, as for the exact version # I looked in "properties and it does not give the exact version number ... Operating System is Windows 10. There maybe some compatibility issues.

 

[Lindee]

I have determined that: The reason I can't get the formula to work is that I don't know how to copy and past the formula to my workbook. DID I MENTION THAT I KNOW VERY LITTLE ABOUT EXCEL LOL... Please tell me how to copy and past formulas.
Thanks again.

 

[Lindee]

Your silence is deafing, thanks any way.

 

[Marcelo Branco]

Your silence is deafing, thanks any way.

Did you try to type the formula in a cell?
Choose an empty cell and type, character by character:
= ISNUMBER(A2)
Tell us the result (True or False?)

M.

 

[Lindee]

The cell does nothing.... the formula just sits there in the cell
like this:
[TABLE="width: 390"]
<colgroup><col width="390"></colgroup><tbody>[TR]
[TD="class: xl67, width: 390"]=ISNUMBER(A2)
[/TD]
[/TR]
</tbody>[/TABLE]

 

[Marcelo Branco]

This usually occurs when the cell is formatted as text. Select the cell, right-click, pick Format Cell, and choose General.
Type again the formula in the cell.

M.

 

[Lindee]

I followed your instructions word for word and still the same problem.

 

[Dryver14]

It looks to me like you have a space in front of the formula in the cell where it is sitting, click on it and before the = sign, try either backspace or delete