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

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

canon_user808 said:

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

Click to expand...

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.

Fallooza said:

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.

Click to expand...

IT WORKED! i cant figure out how or why that formula works but it does.

Fallooza said:

IT WORKED! i cant figure out how or why that formula works but it does.

Click to expand...

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.

jhelm007 said:

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.

Click to expand...

thanks alot! you da man.