+ Reply to Thread
Results 1 to 4 of 4

Multiple IF formulas

  1. #1
    Registered User
    Join Date
    05-08-2015
    Location
    london, englsd
    MS-Off Ver
    2010
    Posts
    2

    Multiple IF formulas

    Hello,

    I need a cell to have a different formula if another in its row shows a certain value.

    i,e if A1 is 10 and A2 is 20, A3 must be A2-10 = 10, but this changes as the value in Column 1 changes -> if B1 is 20 and B2 is 50, B3 must be B2-20 = 30 ect.

    I need three different possible formulas.

    Have been a bit stuck on this and it would save me so much time in work.

    If anyone can help, if its even possible, it would be massively appreciated!

    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.67 - (22111300)
    Posts
    7,506

    Re: Multiple IF formulas

    so isnt that just
    A2-A1
    and copy that across
    I'm clearly not understanding the requirement?

    Please upload a sample of your workbook to the forum, Make sure you have removed any private information, remember this is a public forum and so available to anyone
    Would like to see an example of your data and also a manual mock up of the expected results you want to achieve.

    To attach a file to your post,
    click "Go advanced" (next to quick post),
    scroll down until you see "manage Attachments",
    click that and select "add files" (top right corner).
    click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

    Once the upload is completed the file name will appear below the input boxes in this window.
    You can then close the window to return to the new post screen.
    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
    Registered User
    Join Date
    05-08-2015
    Location
    london, englsd
    MS-Off Ver
    2010
    Posts
    2

    Re: Multiple IF formulas

    Hi, thanks for the reply, i'll upload the file in a second.

    =IF(A9=2,SUM(B9-2),SUM(B9-3)) that's the equation I've got working so far, i just need a third possibility, value_if_true/false only allows two options?

    I assume this is quite easy in reality!

  4. #4
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.67 - (22111300)
    Posts
    7,506

    Re: Multiple IF formulas

    so what is the third value and what does A9 = to get the third value
    a nested IF maybe

+ 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. formulas for search based on multiple criteria in multiple columns
    By oneworld in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-02-2013, 06:57 AM
  2. Replies: 0
    Last Post: 04-14-2013, 08:39 PM
  3. Multiple formulas in selected cell without damaging previous formulas.
    By excel5111987 in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 02-05-2011, 06:15 AM
  4. Copy formulas to adjacent columns - multiple cells and multiple sheets
    By swanseaexcel in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 01-12-2011, 06:21 AM
  5. Sort multiple columns with multiple formulas without returning #R
    By bellsjrb in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-14-2006, 05:00 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