Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 422
  • Last Modified:

Lotus Smartsuite formula problem

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
Kdankwah
Asked:
Kdankwah
  • 2
1 Solution
 
patrickabCommented:
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
 
patrickabCommented:
Please let me know what happened and how you got on.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now