+ Reply to Thread
Results 1 to 3 of 3

change the contents of a cell by means of a formula

  1. #1
    Registered User
    Join Date
    11-13-2008
    Location
    The Netherlands
    Posts
    21

    change the contents of a cell by means of a formula

    In cell A1 is a formula which gives output in A1.
    When the shown output of cell A1 is greater than a specified value, say 5, then the contents of Cell A2 should show the output of cell A1. (5)
    I tried to achieve this by means of a function but no succes.
    Can you help me to solve this?

  2. #2
    Valued Forum Contributor mudraker's Avatar
    Join Date
    11-10-2003
    Location
    Melbourne, Australia
    Posts
    3,983

    Re: change the contents of a cell by means of a formula

    Place this formula in A2 - It displays nothing if value is 5 or less
    =IF(A1>5,A1,"")
    Please Read Forum Rules Before Posting
    Wrap VBA code by selecting the code and clicking the # icon or Read This
    How To Cross Post politely

    Top Excel links for beginners to Experts

    If you are pleased with a member's answer then use the Scales icon to rate it
    If my reply has assisted or failed to assist you I welcome your Feedback.

  3. #3
    Registered User
    Join Date
    11-13-2008
    Location
    The Netherlands
    Posts
    21

    Re: change the contents of a cell by means of a formula

    Thank you for your help.

    The problem is however a little more complex:

    The formula in Cell A1 shows the actual max allowed range of a graph. This range is a part of the graph.
    Cell A2 is the linked cell of a scrollbar .
    This scrollbar is also active on this graph but controls the complete graph.
    When the value of cell A2, the linked cell, is greater than the max value of the allowed range, the display of the graph is no longer correct.

    My idea was to change the value of the linked cell A2 to the max value shown in A1 in order to get the graph again within its limits.
    But I do not know how to achieve this.

+ 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