Results 1 to 4 of 4

Need to Apply two different condition in single formula to a Timelog Sheet

Threaded View

Prashant_Shinde Need to Apply two different... 03-24-2015, 07:06 AM
cbatrody Re: Need to Apply two... 03-24-2015, 07:16 AM
Prashant_Shinde Re: Need to Apply two... 03-24-2015, 07:28 AM
cbatrody Re: Need to Apply two... 03-24-2015, 07:42 AM
  1. 03-24-2015, 07:06 AM #1
    Prashant_Shinde is offline
    Registered User
    Join Date
    03-24-2015
    Location
    India
    MS-Off Ver
    2013
    Posts
    2

    Need to Apply two different condition in single formula to a Timelog Sheet

    Hi,

    For a attached time log sheet "Table 2", I would like to apply a formula with 2 different conditions.

    Condition 1.= If a particular cell ( F22 as in attached sheet) show "Sat" or "Sun" ( Other than working day) then F23 cell show "WO" ( weekly Off)

    Condition 2= in this if "Table 1" cell show any cell greater than "ZERO" then formula show that value, else if Cell show value equal to "ZERO" then "table 2", should show "L" as leave. Formula for that condition already applied to "Table 2" =IF(F10=0,"L",F10)

    My requirement is that on Saturday and Sunday, Instead of "L", I need "WO" ( weekly Off).

    Please help me for the same.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Need to Apply two different condition in single formula to a Timelog Sheet
    By Prashant_Shinde in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 03-24-2015, 06:59 AM
  2. How to apply a percentage formula across multiple cells/single worksheet
    By Hooliegirl in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-01-2013, 09:20 AM
  3. Formula to apply to multiple worksheets when a condition is met.
    By RunHard in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 04-03-2009, 03:06 AM
  4. Apply Single Formula in Batch
    By Xorlev in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-07-2007, 11:28 AM
  5. Apply a single formula on multiple cells
    By L.Weilong in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-14-2007, 10:52 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1