+ Reply to Thread
Results 1 to 6 of 6

Need to check 2 cells to see what of 2 values or blanks are to be entered into one cell

  1. 01-29-2013, 09:05 PM #1
    Launchnet
    Launchnet is offline
    Valued Forum Contributor
    Join Date
    09-04-2007
    Location
    Ontario, Ca
    Posts
    624

    Need to check 2 cells to see what of 2 values or blanks are to be entered into one cell

    I need a IF statement to do the following. No idea beyond my description.

    Cell AN is where I need the formula, such as:

    Please Login or Register  to view this content.
    This is what I've tried, but it won't work.

    Can someone give me an idea how to make it work ?

    Thanks
    Matt
    Last edited by Launchnet; 01-29-2013 at 10:55 PM. Reason: Solved
    Thanks for helping . . .
    Matt @ Launchnet
    Reply With QuoteRegister To Reply
  2. 01-29-2013, 09:17 PM #2
    dredwolf
    dredwolf is offline
    Forum Expert dredwolf's Avatar
    Join Date
    10-27-2012
    Location
    Clearwater,Canada
    MS-Off Ver
    Excel 2007
    Posts
    2,649

    Re: Need to check 2 cells to see what of 2 values or blanks are to be entered into one cel

    Try it this way :
    =IF(OR(U18<=0,I18=""),"",U18)

    Hope this helps
    A picture may be worth a thousand words, BUT, a sample Workbook is worth a thousand screenshots!
    -Add a File - click advanced (next to quick post), scroll to manage attachments, click, select add files, click select files, select file, click upload, when file shows up at bottom left, click done (bottom right), click submit
    -To mark thread Solved- go top of thread,click Thread Tools,click Mark as Solved
    If you received helpful response, please remember to hit the * of that post
    Reply With QuoteRegister To Reply
  3. 01-29-2013, 09:17 PM #3
    jeffreybrown
    jeffreybrown is offline
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,327

    Re: Need to check 2 cells to see what of 2 values or blanks are to be entered into one cel

    Maybe...

    =IF(OR(U18<=0,I18=""),"",U18)
    HTH
    Regards, Jeff
    Reply With QuoteRegister To Reply
  4. 01-29-2013, 09:19 PM #4
    Teethless mama
    Teethless mama is offline
    Banned User!
    Join Date
    10-14-2006
    Posts
    1,211

    Re: Need to check 2 cells to see what of 2 values or blanks are to be entered into one cel

    =if(or(u18<=0,u18=""),"",u18)
    Reply With QuoteRegister To Reply
  5. 01-29-2013, 10:52 PM #5
    Launchnet
    Launchnet is offline
    Valued Forum Contributor
    Join Date
    09-04-2007
    Location
    Ontario, Ca
    Posts
    624

    Re: Need to check 2 cells to see what of 2 values or blanks are to be entered into one cel

    Hi Jeffrey - Dredwolf & Teethless . . . Fast and Good work. Teethless, you were on the right track, but you typed a U where it should have been I.

    Thanks again for the fast help.
    Reply With QuoteRegister To Reply
  6. 01-29-2013, 10:54 PM #6
    dredwolf
    dredwolf is offline
    Forum Expert dredwolf's Avatar
    Join Date
    10-27-2012
    Location
    Clearwater,Canada
    MS-Off Ver
    Excel 2007
    Posts
    2,649

    Re: Need to check 2 cells to see what of 2 values or blanks are to be entered into one cel

    You are welcome
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1