Results 1 to 14 of 14

Using IF THEN ELSE in Excel 2007

Threaded View

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

    Using IF THEN ELSE in Excel 2007

    I need to write a formula for the column I in an excel worksheet.

    For I4:

    IF(A4=A3 & A3=A2) then (I4= (220-(G2+G3+G4))/200) Else (I4=((220-G4)/220))

    Similarly,
    For I5:

    IF(A5=A4 & A4=A3& A3=A2) then (I5= (220-(G2+G3+G4+G5))/200) Else (I5=((220-G5)/220))

    and so on...

    Could you please provide the correct syntax to use this logic?

    Daymaker
    Last edited by daymaker; 06-20-2011 at 01:13 AM. Reason: Solved

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