New To Mac-Forums?

Welcome to our community! Join the discussion today by registering your FREE account. If you have any problems with the registration process, please contact us!

Get your questions answered by community gurus Advice and insight from world-class Apple enthusiasts Exclusive access to members-only contests, giveaways and deals

Join today!

 
Start a Discussion
 

Mac-Forums Brief

Subscribe to Mac-Forums Brief to receive special offers from Mac-Forums partners and sponsors

Join the conversation RSS
OS X - Apps and Games Discussion of applications and games available for Mac OS X.

Appleworks spreadsheet help


Post Reply New Thread Subscribe

 
Thread Tools
Fallooza

 
Member Since: May 13, 2005
Posts: 2,417
Fallooza has a brilliant futureFallooza has a brilliant futureFallooza has a brilliant futureFallooza has a brilliant futureFallooza has a brilliant futureFallooza has a brilliant futureFallooza has a brilliant futureFallooza has a brilliant futureFallooza has a brilliant futureFallooza has a brilliant future

Fallooza is offline
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
File Type: png Picture 1.png (45.4 KB, 13 views)
QUOTE Thanks
canon_user808
Guest
 
Posts: n/a

Try this-
=IF(C3=0,"",C3+D2)
QUOTE Thanks
Fallooza

 
Member Since: May 13, 2005
Posts: 2,417
Fallooza has a brilliant futureFallooza has a brilliant futureFallooza has a brilliant futureFallooza has a brilliant futureFallooza has a brilliant futureFallooza has a brilliant futureFallooza has a brilliant futureFallooza has a brilliant futureFallooza has a brilliant futureFallooza has a brilliant future

Fallooza is offline
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.
QUOTE Thanks
Fallooza

 
Member Since: May 13, 2005
Posts: 2,417
Fallooza has a brilliant futureFallooza has a brilliant futureFallooza has a brilliant futureFallooza has a brilliant futureFallooza has a brilliant futureFallooza has a brilliant futureFallooza has a brilliant futureFallooza has a brilliant futureFallooza has a brilliant futureFallooza has a brilliant future

Fallooza is offline
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.
QUOTE Thanks
jhelm007

 
jhelm007's Avatar
 
Member Since: Oct 18, 2004
Location: Norfolk, VA, USA
Posts: 631
jhelm007 is a jewel in the roughjhelm007 is a jewel in the rough
Mac Specs: MacBook: 2GHz, 2GB RAM, 120GB HD; PowerTower Pro (300MHz G3 clone): 608MB RAM, 10GB HD

jhelm007 is offline
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.
QUOTE Thanks
Fallooza

 
Member Since: May 13, 2005
Posts: 2,417
Fallooza has a brilliant futureFallooza has a brilliant futureFallooza has a brilliant futureFallooza has a brilliant futureFallooza has a brilliant futureFallooza has a brilliant futureFallooza has a brilliant futureFallooza has a brilliant futureFallooza has a brilliant futureFallooza has a brilliant future

Fallooza is offline
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.
QUOTE Thanks

Post Reply New Thread Subscribe


« shopping cart/shipping calculator | quicktime problems »
Thread Tools

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off
Forum Jump

Similar Threads
Thread
Thread Starter
Forum
Replies
Last Post
Linking Spreadsheet Columns in Appleworks Mothmom Running Windows (or anything else) on your Mac 0 12-11-2005 10:43 AM
AppleWorks dsmith6 OS X - Operating System 4 09-11-2005 07:00 AM
AppleWorks amendolair Switcher Hangout 6 04-27-2005 05:57 AM
AppleWorks - I can't find it. At all. Extra Terrestri Switcher Hangout 5 02-05-2005 05:14 PM
Appleworks? jaydhall OS X - Operating System 2 01-12-2004 05:00 PM

All times are GMT -4. The time now is 01:06 PM.

Powered by vBulletin
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
X

Welcome to Mac-Forums.com

Create your username to jump into the discussion!

New members like you have made this community the ultimate source for your Mac since 2003!


(4 digit year)

Already a member?