|Posted: December 7, 2011, 12:26 pm - IP Logged|
Can someone tell me how to convert a number in excel to equal another number. For ex. convert 1 to a 2 anytime you see a 1 convert it to a 2.
You can use the =IF(,,) function.
=IF("your test","your result if the test is true","your result if the test is false")
Example for data in cell A1:
This means: If the data in A1 is equal to 1 , then add 1 to the number to get 2 , otherwise just reutrn the original number in A1.
There are a few other ways, but this is fairly simple.
Presented 'AS IS' and for Entertainment Purposes Only.
Any gain or loss is your responsibility.
Use at your own risk.
Order is a Subset of Chaos
Knowledge is Beyond Belief
Wisdom is Not Censored
Douglas Paul Smallish