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 Mike Lewis 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: *

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

Part and Inventory Search

Back
Top