[Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Lotus Smartsuite formula problem

Posted on 2004-03-26
2
Medium Priority
?
420 Views
Last Modified: 2010-04-22
Hi,

I have a long formula of adding cell addresses (i.e. sheetname:a1 + sheetname:a1, etc with sheetname being the name of the sheet) from about 40 sheets.  My problem is right now I  dont want to add some of the cells in the original formula.  Is there a way one can make Lotus ignore those cells I dont want withiin the formula?
 I dont want to delete these cells addresses in the forumula because I may use them again
in the future and its time consuming redo that. Basically, I want to insert a label within a formula.

Please Help
0
Comment
Question by:Kdankwah
  • 2
2 Comments
 
LVL 45

Expert Comment

by:patrickab
ID: 10697834
Test the contents of the cells you want to add up for the "datatype" using @cell(attribute;location) and if OK then use them, otherwise not. Thus:

@IF(@CELL("DATATYPE",C5..C5)="V",C5,"")

"datatype" "v" is a formula or numeric value. Have a look at the Help file in Lotus123 for allthe attributes you can test for using @cell(attribute;location).

Hope that helps
0
 
LVL 45

Accepted Solution

by:
patrickab earned 2000 total points
ID: 10751285
Please let me know what happened and how you got on.
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This is an old article, please see an updated version of this article, located here: http://www.experts-exchange.com/articles/23619/Notes-8-5x-Windows-7-Notes-info-and-tips.html
This article covers general Notes 8.5 troubleshooting information including recreating the Notes\Data folder.
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…
Suggested Courses
Course of the Month20 days, 13 hours left to enroll

864 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question