Results 1 to 6 of 6
  1. #1


    Member Since
    May 13, 2005
    Posts
    2,410
    Appleworks spreadsheet help
    im very new ta workin with Appleworks. with the Help feature ive managed ta make a simple spreadsheet. my problem is when i put in a formula and have it fill the column, it repeats the answer down the whole column. in my example you can see that D3 has the formula =C3+D2 and repeats in the column in consecutive order. i would like it ta stop doin the formula untill a entry is put in C. or one that is 0< or 0>. I hope someone can make sense of this. if not look at the pic and you will see what im talkin about. and if you still dont know what the crap im talkin about, thanks for atleastvreadin this my whole post. Thanks
    Attached Images Attached Images

  2. #2
    canon_user808
    Guest
    Try this-
    =IF(C3=0,"",C3+D2)

  3. #3


    Member Since
    May 13, 2005
    Posts
    2,410
    Quote Originally Posted by canon_user808
    Try this-
    =IF(C3=0,"",C3+D2)
    ill give it a try as soon as i can. thanks foe the help. i gave up on this thread and just didnt think there was an answer.

  4. #4


    Member Since
    May 13, 2005
    Posts
    2,410
    Quote Originally Posted by Fallooza
    ill give it a try as soon as i can. thanks foe the help. i gave up on this thread and just didnt think there was an answer.
    IT WORKED! i cant figure out how or why that formula works but it does.

  5. #5

    jhelm007's Avatar
    Member Since
    Oct 18, 2004
    Location
    Norfolk, VA, USA
    Posts
    629
    Specs:
    MacBook: 2GHz, 2GB RAM, 120GB HD; PowerTower Pro (300MHz G3 clone): 608MB RAM, 10GB HD
    Quote Originally Posted by Fallooza
    IT WORKED! i cant figure out how or why that formula works but it does.
    It is an if/then statement. If the column c cell contains a zero, then it enters "" which is nothing (in quotation marks). If this requirement is not met then it performs the action described in the formula. Hope that helps for future Spread sheet use.

  6. #6


    Member Since
    May 13, 2005
    Posts
    2,410
    Quote Originally Posted by jhelm007
    It is an if/then statement. If the column c cell contains a zero, then it enters "" which is nothing (in quotation marks). If this requirement is not met then it performs the action described in the formula. Hope that helps for future Spread sheet use.
    thanks alot! you da man.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Is there a spreadsheet that will.................
    By royalpei in forum Switcher Hangout
    Replies: 6
    Last Post: 09-29-2012, 11:24 AM
  2. Spreadsheet
    By Only child in forum OS X - Apps and Games
    Replies: 9
    Last Post: 05-17-2011, 10:31 PM
  3. Help with spreadsheet.
    By heartman6nmh in forum OS X - Apps and Games
    Replies: 1
    Last Post: 12-21-2010, 09:43 PM
  4. iWork spreadsheet?
    By rogerinlondon in forum Apple Rumors and Reports
    Replies: 20
    Last Post: 08-10-2007, 01:18 PM
  5. Linking Spreadsheet Columns in Appleworks
    By Mothmom in forum Running Windows (or anything else) on your Mac
    Replies: 0
    Last Post: 12-11-2005, 11:43 AM

Posting Permissions

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