+ Reply to Thread
Results 1 to 1 of 1

Using IF THEN ELSE in Excel 2010

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

    Using IF THEN ELSE in Excel 2010

    For J3:
    IF(A3=A2) && the occurrence of an entry in F3 is for the first time THEN (J3=(20-(F2+F3))/20)
    ELSE J3=J2 - I3.


    For J4:

    IF(A4=A3 & A3=A2) && the occurrence of an entry in F4 is for the first time THEN (J4=(20-(F2+F3+F4))/20)
    ELSE J4=J3 - I4.

    But if,
    IF (A4=A3) but A3 (is not eaual) != A2) && the occurrence of an entry in F4 is for the first time THEN (J4=(20-(F3+F4))/20)
    ELSE J4=J3 - I4.

    Similarly,
    For J5:

    IF(A5=A4 & A4=A3& A3=A2) && the occurrence of an entry in F5 is for the first time THEN (J5= (20-(F2+F3+F4))/20)
    ELSE J5=J4 - I5.

    But if,
    IF (A5=A4 & A4=A3) but A3 (is not eaual) != A2) && the occurrence of an entry in F5 is for the first time THEN (J4=(20-(F3+F4))/20)
    ELSE J4=J3 - I4.
    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.
    Attached Files Attached Files
    Last edited by daymaker; 01-10-2012 at 12:28 AM. Reason: wrong question

+ 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