+ Reply to Thread
Results 1 to 3 of 3

if function 3 variables

  1. #1
    Registered User
    Join Date
    02-26-2015
    Location
    Cayman
    MS-Off Ver
    2007
    Posts
    2

    if function 3 variables

    hi can anyone help with this , or let me know if this is even possible.

    Thanks

    Format a cell with 3 different rules

    If a1=1 , the add b1+c1+d1 in cell e1
    If a1=2, then add c1+d1 in cell e1
    If a1 =3, then copy d1 to e1

  2. #2
    Valued Forum Contributor
    Join Date
    09-10-2012
    Location
    Los Angeles, CA
    MS-Off Ver
    Excel 2010
    Posts
    929

    Re: if function 3 variables

    Try this formula in E1... nested IF statements...

    =IF(A1=1,B1+C1+D1,IF(A1=2,C1+D1,IF(A1=3,D1)))

  3. #3
    Registered User
    Join Date
    02-26-2015
    Location
    Cayman
    MS-Off Ver
    2007
    Posts
    2

    Re: if function 3 variables

    Thanks djapigo, you're a lifesaver !!

+ 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. Using IF function for two different variables
    By doshitushar in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-17-2013, 03:02 AM
  2. [SOLVED] IF function with three variables
    By freethinker in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 02-14-2013, 07:03 AM
  3. Replies: 3
    Last Post: 09-11-2012, 02:03 AM
  4. 2 variables in a function
    By unclesnoop in forum Excel General
    Replies: 3
    Last Post: 01-28-2011, 10:58 AM
  5. Excel 2007 : Function with three variables
    By SWPRINT in forum Excel General
    Replies: 2
    Last Post: 11-02-2010, 12:25 PM

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