Results 1 to 6 of 6

Thread: If or - if and

  1. #1
    3 Star Lounger
    Join Date
    Jun 2005
    Posts
    386
    Thanks
    3
    Thanked 0 Times in 0 Posts
    I would like to have a cell testing at least two other cells in the same row obviously different colums. the test would be if one colum had a any text in it then that text would be recorded in the testing column or if the other column had text in it starting with "time to sell" it would copy the whole cell into the testing column. the columns being tested would only have text in one column at a time.

    Any ideas.

    Thanks

  2. #2
    Star Lounger
    Join Date
    Apr 2004
    Posts
    66
    Thanks
    0
    Thanked 0 Times in 0 Posts
    What about something along the lines of:

    =IF(F3="",IF(E3="",D3,E3),F3)

  3. #3
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,434
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    I take it from your specification that the second text cell can have test starting with something other than "time to sell"?

    If this assumption is correct you need: =IF(F3="",IF(UPPER(left(E3,12))="TIME TO SELL",E3,D3),F3)

    Note: using the UPPER function will solve any data input errors concerning text case.

    RG
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  4. #4
    3 Star Lounger
    Join Date
    Jun 2005
    Posts
    386
    Thanks
    3
    Thanked 0 Times in 0 Posts
    Thanks for the assistance. I am attaching a workbook with two tabs. The "FIRST CUT" tab shows what the result of my spreadsheet. the "FINAL" tab ( red) shows the final result. The question is how do I get to the 'FINAL' by eliminating the blank cells.

    Thank you
    Attached Files Attached Files

  5. #5
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    Delete Row 1
    Delete Cols B:F
    Select Column A
    Edit - go to [special]
    Select Blanks [OK]
    right-click selection - delete
    shift cells up

    Steve

  6. #6
    5 Star Lounger
    Join Date
    Dec 2009
    Location
    East Coast, USA
    Posts
    993
    Thanks
    8
    Thanked 43 Times in 43 Posts
    Hello MNN - You could try an Auto Filter on your Data.

    Highlight all of your Data in A1 thru F27, then choose Data/Filter/Auto Filter
    Click on the drop down arrow in Column A and choose Non Blanks.
    To get back to show all of your Data, click down arrow and choose All.

    I added a tab to your file - It is Green and labeled "FIRST Cut rev".
    Results are in Col A. Results are the same as your Red Final tab.

    Is that what you are looking for?

    Tim

    [attachment=88688:IF OR TWO rev.xls]
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •