Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

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

Posted on 2004-10-18
9
Medium Priority
?
277 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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 

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

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

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

For Desktop Techs: How to retain a user's Notes configuration data when swapping out the end user's computer. (Assuming that you are not upgrading to a completely different version of Notes client) All you need to do is: 1) install Notes o…
This article covers general Notes 8.5 troubleshooting information including recreating the Notes\Data folder.
In response to a need for security and privacy, and to continue fostering an environment members can turn to for support, solutions, and education, Experts Exchange has created anonymous question capabilities. This new feature is available to our Pr…
Screencast - Getting to Know the Pipeline

610 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