+ Reply to Thread
Results 1 to 2 of 2

Using the IF function to change multiple cells

  1. #1
    Registered User
    Join Date
    06-11-2014
    Posts
    3

    Using the IF function to change multiple cells

    Firstly, hello. I know this is suppose to be my "Hello, I'm new to these forums" and such, but I'll spice this introduction up a but with a problem I've been having with the Excel IF function.

    Simply, what I'm trying to do, is change multiple cells depending on the value of a single cell.

    For example, I might have an IF function that checks if the value in cell A1 is equal to 1.

    IF the value in A1 is equal to 1, all I want to do is make the values of Cells B1 to, let's say, G1, equal to the same value.

    Is that possible? Because from every example I've seen of the IF function, all it does is display something like "FOUND", or "NOT FOUND" for the true and false results of the function. I want the True and False results to do a little more than that.

    I have Google countless sites to try to find a way to do this, but to no avail. If anyone knows how to do this, please let me know, I would greatly appreciate it.

    Thank you for your time.

  2. #2
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2021
    Posts
    4,361

    Re: Using the IF function to change multiple cells

    Welcome to the forum
    I think people forget the word "THANK YOU!!!!" Do you still know it???

    There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "

    Regards,
    Vladimir

+ 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: 4
    Last Post: 03-08-2014, 02:03 PM
  2. Multiple cells change value depending on another cells value
    By ragingfred in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-15-2013, 03:47 PM
  3. Need Sum function to change cells each day
    By Daire in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-07-2012, 05:14 PM
  4. Need help to change multiple criteria from if function to Case function.
    By indkitty in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-29-2012, 10:42 PM
  5. VBA function to change multiple cell values?
    By Econdoc1 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-23-2010, 03:13 AM

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