+ Reply to Thread
Results 1 to 2 of 2

calculation query

  1. #1
    Registered User
    Join Date
    08-25-2010
    Location
    london, enngland
    MS-Off Ver
    Excel 2007
    Posts
    1

    Exclamation calculation query

    Hi fellow members,

    I have a formula query?

    I have created the following formula to give accurate readings for employee
    holiday annd staff training register

    =IF(COUNT(E4:E13)>2, "NOT OK","OK")

    this formula allows me to see if it is 'ok' or 'not ok' to allow them to take annual leave
    if less than 2 members are off in the department.

    what i am now trying to achieve is now that i have used a numeric value to give me that answer i would like to change it to dominate a letter of the alphabet but still give a running total of number of days taken for holiday but not for sick days, public holidays or traning

    please see the attached speadsheet

    thank you dave
    Attached Files Attached Files

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: calculation query

    Welcome to the forum.

    Please take a few minutes to read the forum rules, and then amend your thread title accordingly.

    Thanks.
    Entia non sunt multiplicanda sine necessitate

+ Reply to 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