+ Reply to Thread
Results 1 to 2 of 2

Set condition of cell to change its value based on "if" formula applied to same cell.

  1. #1
    Registered User
    Join Date
    09-22-2020
    Location
    USA
    MS-Off Ver
    windows 10 enterprise
    Posts
    1

    Set condition of cell to change its value based on "if" formula applied to same cell.

    So I am not entirely new to excel, but I do not have very much experience in formulas like "IF" functions etc. I am trying to set a condition for a cell (i.e "A1")that is not a "formatting" condition. I want to be able to enter a value into a cell(A1), and based on a formula related to other cells, I would like that same cell(A1) to change its value based on said formula. Is there a way to do this? It seems like a pretty simple function, but I cannot see any way to do it. If I did not explain it well, I can give a more specific example as needed. in hopes of getting a quick answer I am keeping this short to start. Thanks!

  2. #2
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.83 (24031120))
    Posts
    8,686

    Re: Set condition of cell to change its value based on "if" formula applied to same cell.

    you will need VBA - not my expertise - to change the cell contents after typing something in
    An IF can modifiy another cell and change the output

    so in B1 you could have an IF() that will change based on the value of A1 and other cells

    Lets say you wanted to multiply A1 by 5 if C1 = "yes" and leave the same value as A1 if not YES

    in B1
    =IF( C1 = "YES", A1*5, A1)
    Wayne
    if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 17
    Last Post: 08-04-2017, 01:49 PM
  2. "Worksheet change" not changing cell on other sheet to match target cell "fill".
    By Ochimus in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 10-02-2015, 12:02 PM
  3. [SOLVED] if formula needed to populate either "1" or "0" based on number of units in another cell
    By excelteam777 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-07-2015, 11:24 AM
  4. Replies: 1
    Last Post: 11-02-2013, 11:22 AM
  5. Change "Parent" cell based on results of multiple "Children" cells
    By ccowman in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 12-14-2012, 02:33 AM
  6. Macro "if" loop, change value cell if condition in other cell is met
    By DMR1712 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-15-2010, 03:32 PM
  7. If statement with "left" condition applied to a date
    By Portuga in forum Excel General
    Replies: 3
    Last Post: 03-11-2008, 07:03 PM

Tags for this Thread

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