?
Solved

Lotus 123 @IF(H47#OR#F47,F47-H47,"") means?

Posted on 2004-10-18
9
Medium Priority
?
266 Views
Last Modified: 2010-04-22
Where can I find references to the above @if Condition? I have also come across the same but with #AND#.
0
Comment
Question by:win2ok
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 3
9 Comments
 

Expert Comment

by:bnewett
ID: 12348008
@IF(H47#OR#F47,F47-H47,"")

It looks at cells h47 and f47, if neither cell contains a numeric value the cell the IF is in will display nothing, if either cell contains a numeric value the cell the if is in will display the difference between f47 and h47.

May not be the answer you are looking for, but that's what will hapen.

Bill
0
 

Author Comment

by:win2ok
ID: 12355718
Thanks, I had worked that out, but where can I reference it?
0
 
LVL 45

Expert Comment

by:patrickab
ID: 12385412
win2ok - what do you mean by 'reference it' ? Patrick
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:win2ok
ID: 12398085
A book, a function list, a help reference. Somewhere it is mentioned, as it is not in the @IF function Help for Lotus.
0
 
LVL 45

Accepted Solution

by:
patrickab earned 200 total points
ID: 12412043
win2ok

It's all in the Lotus123 Help files.

@IF() is in the Lotus123 Help files as are the logical operators - AND, OR, NOT. If you type 'logical' into the help Find dialogue box and tick the 'Argument types' and press Display you will get help on those operators.

Patrick
0
 
LVL 45

Expert Comment

by:patrickab
ID: 12456268
win2ok - How did you get on? Patrick
0
 

Author Comment

by:win2ok
ID: 12459669
I pressed the Accept button - is that what you do when you obtain a satisfactory answer?

Michael
0
 
LVL 45

Expert Comment

by:patrickab
ID: 12506939
Michael,

You need to press the Accept button opposite the answer that gives you the information you were seeking, then award the grade you think appropriate and only then press Submit.

Patrick
0
 
LVL 45

Expert Comment

by:patrickab
ID: 12531273
Michael - Many thanks for the grade - pleased to help - Patrick
0

Featured Post

Want to be a Web Developer? Get Certified Today!

Enroll in the Certified Web Development Professional course package to learn HTML, Javascript, and PHP. Build a solid foundation to work toward your dream job!

Question has a verified solution.

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

You’ve got a lotus Domino web server, and you have been told that “leverage browser caching” is a must do. This means that we have to tell the browser everywhere in the web to use cache. In other words, we set (and send) an expiration date in the HT…
Lack of Storage capacity is a common problem that exists in every field of life. Here we are taking the case of Lotus Notes Emails, as we all know that we are totally depend on e-communication i.e. Emails. This article is fully dedicated to resolvin…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
Suggested Courses

752 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