Solved

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

Posted on 2004-10-18
9
253 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
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

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.

 

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 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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

Problem "Can you help me recover my changes?  I double-clicked the attachment, made changes, and then hit Save before closing it.  But when I try to re-open it, my changes are missing!"    Solution This solution opens the Outlook Secure Temp Fold…
This article covers general Notes 8.5 troubleshooting information including recreating the Notes\Data folder.
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

856 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