Results 1 to 2 of 2
  1. #1
    iworks numbers formulae

    Member Since
    Aug 13, 2013
    Posts
    1
    iworks numbers formulae
    Hi, I have a question about formulae in iworks numbers relating to the following problem.

    I have 3 numerical cells, A, B and C

    I want to input figures in cells A and B to give a certain return in C

    The criteria I am using are as follows:

    IF A>B THEN IF TRUE C=2, IF FALSE C=0
    IF A=B THEN C=1 EXCEPT IF A=0 THEN C=0

    Can any please help with writing a formula for this?

  2. #2
    iworks numbers formulae
    Raz0rEdge's Avatar
    Member Since
    Jul 17, 2009
    Location
    MA
    Posts
    8,184
    Specs:
    27" i7 iMac, 24" iMac, 13" Macbook Air, iPhone 5 & 5S, iPod Nano 7th Gen, iPad 2 16GB WiFi, iPad 3
    Try the following formula:
    Code:
    =IF(A2>B2, 2, IF(A2=B2, IF(A2=0, 0, 1), 0))
    I used the following values for A and B

    A B C
    1 2 = 0
    4 3 = 2
    5 5 = 1
    0 0 = 0

    See if that works for you..
    --
    Regards
    ...Ashwin



    Be sure to read the Community Guidelines | The more information you provide, the better answers you get, remember GIGO.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. I need a IWorks Numbers GURU!!
    By MacNoob2014 in forum OS X - Apps and Games
    Replies: 3
    Last Post: 08-14-2014, 12:44 PM
  2. Replies: 0
    Last Post: 08-23-2011, 04:14 AM
  3. iworks 09 - save as iworks 08?
    By JaniceWarren in forum OS X - Operating System
    Replies: 5
    Last Post: 12-17-2009, 05:16 PM
  4. learning to use Numbers in iWorks
    By Sai in forum OS X - Apps and Games
    Replies: 4
    Last Post: 10-23-2008, 11:46 PM
  5. Correlating Model Numbers and Apple Part Numbers
    By fziksman in forum Other Hardware and Peripherals
    Replies: 0
    Last Post: 01-30-2007, 04:41 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •