Results 1 to 9 of 9

If Statements help

Threaded View

  1. #1
    Registered User
    Join Date
    08-22-2009
    Location
    Newmarket, Ontario
    MS-Off Ver
    Excel 2003
    Posts
    3

    If Statements help

    I know how to use very basic If statements, but im stuck here :

    I have a spread sheet where i record 3 outcomes, either "y" (yes) "n" (no) or "l" (late). There are 5 of these a day, I want an if statement to add all of the y's and l's together. For example if one day i had 3 y, 1 L and one N i want the cell with the if statement to show 4 (3y+1L)

    Any help would be appreciated. If you need more explanation let me know, the cells with the y's and n's are B5:F5, outcome cell is G5

    What I have got right now is :

    =IF(B5="y",(1),IF(B5="l",(1),(0)))

    But I have to do this in 5 different cells, anyway i can combine it to do it all in one?
    Last edited by Haris75; 08-24-2009 at 04:33 AM. Reason: missing I in beginning

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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