• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 280
  • Last Modified:

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

Where can I find references to the above @if Condition? I have also come across the same but with #AND#.
0
win2ok
Asked:
win2ok
  • 5
  • 3
1 Solution
 
bnewettCommented:
@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
 
win2okAuthor Commented:
Thanks, I had worked that out, but where can I reference it?
0
 
patrickabCommented:
win2ok - what do you mean by 'reference it' ? Patrick
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
win2okAuthor Commented:
A book, a function list, a help reference. Somewhere it is mentioned, as it is not in the @IF function Help for Lotus.
0
 
patrickabCommented:
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
 
patrickabCommented:
win2ok - How did you get on? Patrick
0
 
win2okAuthor Commented:
I pressed the Accept button - is that what you do when you obtain a satisfactory answer?

Michael
0
 
patrickabCommented:
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
 
patrickabCommented:
Michael - Many thanks for the grade - pleased to help - Patrick
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 5
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now