Solved

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

Posted on 2004-10-18
9
249 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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

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

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Domino Mail Routing - Notes Name Networks, DNS, or connection documents? 5 136
Lotus notes email code 6 115
Lotus Notes Calendar Issue 5 112
lotus domino server console error 1 82
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.
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
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…

803 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