+ Reply to Thread
Results 1 to 2 of 2

Changing the Value of a cell automatically

  1. 11-30-2011, 09:36 AM #1
    Birchall
    Birchall is offline
    Registered User
    Join Date
    11-30-2011
    Location
    Norwich england
    MS-Off Ver
    Excel 2010
    Posts
    3

    Unhappy Changing the Value of a cell automatically

    Hi,
    On Excel, I'd like to do something but I'm not sure if it's possible....
    On a sheet I'd like to make Z = Z until a number is input above it and then it will equal that number (say 15 so Z would then =15) but when you remover the number Z = Z again.
    Thanks,
    Adam
    Last edited by Birchall; 11-30-2011 at 11:21 AM.
    Reply With QuoteRegister To Reply
  2. 11-30-2011, 09:42 AM #2
    Kelshaer
    Kelshaer is offline
    Valued Forum Contributor
    Join Date
    08-29-2011
    Location
    Mississauga, CANADA
    MS-Off Ver
    Excel 2010
    Posts
    503

    Re: Changing the Value of a cell automatically

    I am asuming this is for cell Z2
    this is only a formula:
    =if(Z1=15,15,"Z")
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1