Welcome to the MacNN Forums.

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

You are here: MacNN Forums > Enthusiast Zone > Classic Macs and Mac OS > Appleworks Spreadsheet Question?

Appleworks Spreadsheet Question?
Thread Tools
Mac Enthusiast
Join Date: Sep 2000
Location: AB, Canada
Status: Offline
Reply With Quote
Aug 28, 2001, 07:46 PM
Is it possible to assign a verification rule to a particular cell in a spreadsheet? If so you how do you do it?

What I want to ensure is that the user entered number in that cell is greater than a value in another cell. I have done this in MS Excel but I haven't found a way to do it in Appleworks other than in a database. Any help would be greatly appreciated.
As a man comes, so he departs.
Dedicated MacNNer
Join Date: Jul 2001
Location: San Francisco Peninsula
Status: Offline
Reply With Quote
Aug 31, 2001, 10:04 PM
I'm still using Clarisworks 4.0 but I think I can make a suggestion.

There is a conditional structure ( IF statement). You could write a command in a cell that would test the value against the standard value you mention then change it if it was too small.

I suppose you could also write a calculation that would select the maximum of the entered value and the test value.

Is this along the lines of what you were considering?
Happy owner of a new 15" Al PB.
Mac Enthusiast
Join Date: Sep 2000
Location: AB, Canada
Status: Offline
Reply With Quote
Sep 1, 2001, 12:20 PM
What I was really looking for was a validation rule where a pop up custom error message could be displayed. MS Excel has this feature and I was hoping that AppleWorks also had the same freature for the spreadsheet.
As a man comes, so he departs.
Professional Poster
Join Date: Sep 2000
Location: Carbondale, IL
Status: Offline
Reply With Quote
Sep 5, 2001, 03:27 PM
oh oh mr. claris works 4.0 man sir,.....can 4.0 do links within documents?

like lets say i have a title page. then i want to be able to link a word to another spreadsheet that i have done. can 4.0 do that? i know 6.0 and 5.0 can.
AIM: bmichel5581
MacBook 2.2 GHz Intel Core 2 Duo
Thread Tools
Forum Links
Forum 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 On
Privacy Policy
All times are GMT -4. The time now is 05:20 AM.
All contents of these forums © 1995-2015 MacNN. All rights reserved.
Branding + Design: www.gesamtbild.com
vBulletin v.3.8.8 © 2000-2015, Jelsoft Enterprises Ltd., Content Relevant URLs by vBSEO 3.3.2