Results 1 to 5 of 5

Need help with if(and formula.

Threaded View

guleman Need help with if(and formula. 11-06-2013, 09:58 AM
ben_hensel Re: Need help with if(and... 11-06-2013, 10:17 AM
guleman Re: Need help with if(and... 11-06-2013, 11:04 AM
ben_hensel Re: Need help with if(and... 11-06-2013, 11:43 AM
guleman Re: Need help with if(and... 11-07-2013, 05:23 AM
  1. #1
    Registered User
    Join Date
    11-05-2013
    Location
    Denmark
    MS-Off Ver
    Excel 2010
    Posts
    11

    Question Need help with if(and formula.

    Hi there,

    i have been trying to create a formula lately but with no sucess. What is has to do is in cell C6 it should bring up text given in cell a100 or a101.
    To explain the spreadsheet, it basically shows the times for each phase. If the actual start/finish dates are entered higher than planned start/finished, it should make cell C6 pick A100(Late) if not cell A101 (on schedule). PROBLEM: if the time in next actual start phase (Actual start for BOM Approved F12) keeps exceeding the planned E12, it should keep A100, if not, take A101 and so on until the last time in H13.

    It is hard to explain what i acutally need as english is not my mother language but any help would be apreciated. Is there any other formula i could use, that would look at the time entered, if its FALSE(formula) and next one is TRUE and the next after FALSE again, it should change the cell C6 according if its false or true.
    Picture added as attachment, let me know if anything else is needed.
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. how to hide formula in formula box, view lookup result in formula box?
    By vengatvj in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-14-2013, 04:06 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