+ Reply to Thread
Results 1 to 2 of 2

IF THEN ELSE simple formula

  1. #1
    Registered User
    Join Date
    06-16-2011
    Location
    Bangalore
    MS-Off Ver
    Excel 2007
    Posts
    40

    IF THEN ELSE simple formula

    Hello all,
    I've written down some formulas to calcuation the effort on the following basis:

    Total number of screens that could be tested in a CW - 220

    Maximum Number of screens Per person per week - 20

    Now, the logic goes this way :

    For J3:
    IF(A3=A2) THEN J3=J2 - I3.
    Else J3 = (220-F3)/220


    For J4:

    IF(A4=A3) THEN J4= J3-I4
    ELSE J4= (220-F4)/220

    Similarly,
    For J5:

    IF(A5=A4) THEN J5= J4-I5
    ELSE J5= (220-F4)/220

    and so on...

    Note :In the above mentioned formual, it should add up values in F only if, the values in A are identical.

    So ideally, in J6 I should be getting the result as (90.91-2.73) i.e J5-I6.

    Could you please suggest me the correct formula for this?
    Attached Files Attached Files
    Last edited by daymaker; 01-10-2012 at 12:53 AM. Reason: solved by self

  2. #2
    Registered User
    Join Date
    06-16-2011
    Location
    Bangalore
    MS-Off Ver
    Excel 2007
    Posts
    40

    Re: IF THEN ELSE simple formula

    I got the formula. I tried implementing the logic using the formula "=IF(A3=A2, (J2-I3),(220-F3)/220)" in A3 and it worked

+ Reply to Thread

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