Results 1 to 6 of 6

Must I use multiple formulas to fill 3 seperate cells?

Threaded View

Jesi327 Must I use multiple formulas... 05-26-2011, 09:04 AM
zbor Re: Complicated formula 05-26-2011, 09:09 AM
zbor Re: Complicated formula 05-26-2011, 09:13 AM
Jesi327 Re: Must I use multiple... 05-26-2011, 09:44 AM
zbor Re: Must I use multiple... 05-26-2011, 09:48 AM
Jesi327 Re: Must I use multiple... 05-26-2011, 09:59 AM
  1. #1
    Registered User
    Join Date
    05-26-2011
    Location
    Machesney Park, IL
    MS-Off Ver
    Office 2003
    Posts
    3

    Must I use multiple formulas to fill 3 seperate cells?

    I have a spreadsheet for work that is determining production vs. standards. If the scheduled production run is longer than 8 hours or crosses into the next shift - I want the spreadsheet to automatically copy the data from the first column into the following row (which is set-up as a drop-down list).

    I also want the difference (remaining production) moved down the list and for the spreadsheet to determine the remaining time (#.##) that is left on that run.

    Can I do that many fills to different cells based off of one formula or do I need to set up 3 seperate IF statements?
    Last edited by Jesi327; 05-26-2011 at 09:15 AM. Reason: Breaking the rules.

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