MacNN Forums (http://forums.macnn.com/)
-   Classic Macs and Mac OS (http://forums.macnn.com/classic-macs-and-mac-os/)
-   -   Appleworks Spreadsheet Question? (http://forums.macnn.com/64/classic-macs-and-mac-os/43907/appleworks-spreadsheet-question/)

 
crazycylon Aug 28, 2001 08: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 11: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 01: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 04: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 12:54 AM.

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


Content Relevant URLs by vBSEO 3.3.2