+ Reply to Thread
Results 1 to 4 of 4

changin formulas based on one cell input

  1. #1
    Forum Contributor
    Join Date
    12-12-2012
    Location
    Los Angeles
    MS-Off Ver
    Excel 2010
    Posts
    448

    changin formulas based on one cell input

    Hello. I have two sets of data tables and then below I have formulas for the variance. I would also like to have formulas that calculate the percentage variance but without having to create another section. Is it possible to have one cell that says either absolute or %, and that will make all the formulas change based on the input? 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: changin formulas based on one cell input

    yes, you could use an
    IF statement

    =IF( Cell = "absolute" , absolute calculation, % calc)
    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.

  3. #3
    Forum Contributor
    Join Date
    12-12-2012
    Location
    Los Angeles
    MS-Off Ver
    Excel 2010
    Posts
    448

    Re: changin formulas based on one cell input

    Ok, that worked. This part might be tougher: can I change the formatting as well? The absolute formula would be general, and the second formula would be %.

  4. #4
    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: changin formulas based on one cell input

    not sure how to do that , i can format to text , but not retain numbers without using VBA- which I don't know very well
    other members should be able to help

+ 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. [SOLVED] How do I make a cell use different formulas based off of another cell's input?
    By soonerexcel73 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-24-2013, 02:23 AM
  2. [SOLVED] cHANGIN A CELL COLOUR BASED ON A CELL VALUE
    By mohd21uk via OfficeKB.com in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 04-19-2006, 11:50 AM
  3. [SOLVED] Changin Cell Formats using VBA
    By Michael in forum Excel General
    Replies: 1
    Last Post: 01-25-2006, 11:40 AM
  4. Changin values in another cell
    By mkwazeeri in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-13-2005, 10:05 PM
  5. changin amount in cell
    By jillingore in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 04-20-2005, 12:06 AM

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