Results 1 to 2 of 2

if/else statements help needed

Threaded View

  1. #1
    Registered User
    Join Date
    10-18-2011
    Location
    Manchester
    MS-Off Ver
    Excel 2007
    Posts
    25

    if/else statements help needed

    Hi I am trying to complete a formula whereby I have four columns, of these four the first 3 will only ever had 1 completed so lets say its column a,b or c there will only ever be a 1 in one of these columns I then need to determine if there is a 1 in column d,

    so basically the formula would in basic terms be something like this:

    if d1=1 and a1 = 1 then 650, if d1 and b1 then 700, if d1 and c1 then 350

    I would need this to be for all cells in the columns and totals at the bottom?

    Hope I have explained this correctly
    Last edited by turnej; 10-18-2011 at 05:13 PM.

Thread Information

Users Browsing this Thread

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

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