+ Reply to Thread
Results 1 to 2 of 2

Help with cells

  1. #1
    Registered User
    Join Date
    01-12-2007
    Posts
    4

    Help with cells

    New here, My question is that I have a spreadsheet that I want one cell to change at the same time I change a different cell.
    Example:
    I would like cell C27 to change to a percentage number when I change cell B38. I want to type in 0.33 in cell B38 and want cell C27 to read 33%, if I would change it to .25 I would want the other cell to read 25%.

    Can it be done? I can email the spreadsheet to someone if it would help.

    Thanks,
    Red

  2. #2
    Forum Expert
    Join Date
    12-29-2004
    Location
    Michigan, USA
    MS-Off Ver
    2013
    Posts
    2,208
    All you really have to do is format B38 as a %. Go to Format > Cells, click on the Number tab, and select percentage.

    If you also want C27 to show the same %, just type =B38 in the cell, and format as per the above statement.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1