MacNN Forums (
-   Classic Macs and Mac OS (
-   -   Appleworks Spreadsheet Question? (

crazycylon Aug 28, 2001 07:46 PM
Appleworks Spreadsheet Question?
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.
neutrino23 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?
crazycylon 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.
gumby5647 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.
All times are GMT -4. The time now is 09:23 PM.

Copyright © 2005-2007 MacNN. All rights reserved.
Powered by vBulletin® Version 3.8.8
Copyright ©2000 - 2017, vBulletin Solutions, Inc.

Content Relevant URLs by vBSEO 3.3.2