Closed Thread
Results 1 to 4 of 4

(IF formula) Adding extra functions

  1. #1
    Registered User
    Join Date
    03-17-2009
    Location
    aus
    MS-Off Ver
    Excel 2003
    Posts
    6

    (IF formula) Adding extra functions

    I currently have this formula feeding through on the "weekly timetable" worksheet.

    =If(and(Future!$J5>=D5,Future!$J5<=E5),Future!$J5>0,IF(AND(C$4>Quote!$D4,'Weekly Timetable'!D$4<Quote!$E4),Quote!$G4,0))

    I'm not sure if i need to add another IF statement to this.
    Attached is a sample of the workbook.

    Problem:
    I only want cell J5 to be projected in the "Future" spreadsheet if it's > 0, & i only want that number to be projected in the "Weekly Timetable" spreadshee for the weeks it is specified from the dates in cell "Future" F5 & G5.

    Can anyone help?
    Attached Files Attached Files

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: (IF formula) Adding extra functions

    please keep to your original thread - bump if necessary

    http://www.excelforum.com/excel-work...functions.html

  3. #3
    Valued Forum Contributor squiggler47's Avatar
    Join Date
    02-17-2009
    Location
    Littleborough, UK
    MS-Off Ver
    Excel 3.0 to 2007+2010! (couldnt get 2.1 working)
    Posts
    1,013

    Re: (IF formula) Adding extra functions

    I think this is what you want :-

    Please Login or Register  to view this content.

  4. #4
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: (IF formula) Adding extra functions

    squiggler, please do not encourage bad habits - please post to the original thread.

Closed Thread

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