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!

Register Log in
  • Congratulations dencom on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by burnout421

  1. burnout421

    Formula in Lotus Approach 9.8 Form View

    Thanks very much Sue.
  2. burnout421

    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...
  3. burnout421

    Excel formulas in 123

    Bingo! Thanks very much crazybird - just what i was looking for.
  4. burnout421

    Excel formulas in 123

    Thanks for your reply crazybird. The problem seems to be that "" can mean that the cell is blank or contains a zero. That being the case, if any cell contains a zero no result is shown. I want this to work only for blank cells. Is there a way round this?
  5. burnout421

    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...
See more

Part and Inventory Search

Back
Top