Welcome Guest
Log In | Register )
You last visited December 11, 2016, 3:00 am
All times shown are
Eastern Time (GMT-5:00)

How to convert in Excel

Topic closed. 1 reply. Last post 5 years ago by JADELottery.

Page 1 of 1
PrintE-mailLink
Cupcake10's avatar - Lottery-050.jpg

United States
Member #91718
May 23, 2010
690 Posts
Offline
Posted: December 6, 2011, 11:55 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.

    JADELottery's avatar - MeAtWork 03.PNG
    The Quantum Master
    West Concord, MN
    United States
    Member #21
    December 7, 2001
    3675 Posts
    Offline
    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:

    =IF(A1=1,A1+1,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
    Jehocifer