Solved

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

Posted on 2004-10-18
9
243 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
  • 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
 

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
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 
LVL 45

Accepted Solution

by:
patrickab earned 50 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

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

I thought it will be a good idea to make a post as it will help in case someone else faces these issues. I trust this gives an idea how each entry in Notes.ini can mean a lot for the Domino Server to be functioning properly. This article discusses t…
This article covers general Notes 8.5 troubleshooting information including recreating the Notes\Data folder.
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

760 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now