Results 1 to 3 of 3

nested functions

Threaded View

  1. #1
    Registered User
    Join Date
    06-05-2009
    Location
    hampshire
    MS-Off Ver
    Excel 2000
    Posts
    2

    Unhappy nested functions

    I am trying to use the IF function to return a false value if the combined sum of a row is not the same as either of the 1st 2 cells. If that makes any sense!

    This is the formula I would like to use
    =IF(SUM(g3:g9)=g1 or g2 then y if true and x if false

    I thought it would be easy but I can't figure out how to do it

    Please help x
    I am using excel 2000
    Last edited by mortitia_uk; 06-05-2009 at 08:43 AM.

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