Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations dencom on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: burnout421
- Content: Threads
- Order by date
-
Formula in Lotus Approach 9.8 Form View
I have created an inventory database and want to show in a 'Form' view information about qty received, qty on hand and qty moved in last month. The formula itself is simple: Qty on hand at end of last month (A)+ Qty received this month (B)- Qty on hand at end of this month = Qty moved this...- burnout421
- Thread
- Replies: 2
- Forum: Lotus/IBM: Approach
-
Excel formulas in 123
I am using this formula in Excel: =IF(OR(F5="",H5="",I5=""),"",F5+H5-I5) This means that unless all of F5, H5 and I5 are occupied, no result will be shown. If I open the file in 123, the formula is converted as follows: @IF(((F5="")#OR#(H5="")#OR#(I5="")),"",F5+H5-I5 The result is not the same...- burnout421
- Thread
- Replies: 6
- Forum: Office suites general discussion
