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

    IF FUNCTION

    I found that the style in B6 was set as "Label" and the formula would not recognize the number. I change it to "General" and the formula works great. Thanks again. Dave
  2. ellpis

    IF FUNCTION

    The formula is accepted, I have rechecked it twice, but no value shows up in the cell
  3. ellpis

    IF Function

    Thank you for your help. The formula that worked in this situation was simply @SUM(D4)+(E4+F4) since either e4 or f4 would be 0 in each case.
  4. ellpis

    IF FUNCTION

    I would like to develop a total in F6 by multiplying the quantity in B6 by the lowest price in columns C6, D6, or E6. Can you help?
  5. ellpis

    IF Function

    Thanks What actually worked for me is @SUM(D4)-(E4+F4)
  6. ellpis

    IF Function

    I would like to develop a value in cell G4 of sheet B in a multi-sheet workbook that is the result of the following; If E4=0, than D4+F4, If F4=0, than D4+E4. F4 will always be 0 if E4 has a value, and visa-versa. Thanks, Dave
  7. ellpis

    IF Function

    Thank you for your reply. I'm sorry, but I should have told you that this is a lotus.123 program. I tried the formule that you suggested and it did not work. Also, if E4 has a figure than F4 will always be 0. The same goes for F4, E4 will always be 0.
  8. ellpis

    IF Function

    I would like to produce a result in a cell G4 on sheet B of a multiple sheet workbook as follows; If E4=0, the sum of D4+F4, If F4=0, the sum of D4+E4 Please advice Thanks, Dave

Part and Inventory Search

Back
Top