Results 1 to 5 of 5

Need help with if(and formula.

Threaded View

  1. #3
    Registered User
    Join Date
    11-05-2013
    Location
    Denmark
    MS-Off Ver
    Excel 2010
    Posts
    11

    Re: Need help with if(and formula.

    It did not work, probably because you could not get your hands on it. Ill attach a test file. In it, you can see, that in cell d11 i have entered time that is meets the time in e11, but the cell c6 stays a100(late) What i want to achieve is the cell c6 changing to either a100 or a101 if the entered actual times exceeds or meets the planned times in cells e7:e13; g7:g13. So adding a time in actual time cells should change the c6 either to a100 or a101
    Attached Files Attached Files

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