+ Reply to Thread
Results 1 to 3 of 3

Please Combine these 2 formulas, the work individually but not together.

  1. #1
    Forum Contributor
    Join Date
    01-29-2018
    Location
    United states
    MS-Off Ver
    2019
    Posts
    242

    Please Combine these 2 formulas, the work individually but not together.

    =IF(C23="",(""),(K42))

    =IF(C24&C23="",(K42))

    what i am trying to get it to do is if c23 is blank or cells c23 and C24 are blank K42

    Thanks

  2. #2
    Forum Expert
    Join Date
    02-10-2019
    Location
    Georgia, USA
    MS-Off Ver
    Office 365
    Posts
    2,830

    Re: Please Combine these 2 formulas, the work individually but not together.

    So you're basically saying if C23 is blank, then K42. C24 doesn't matter whether it's blank or not based on what you are saying, so the equation would be:
    =IF(C23="",K42,"")

    OR, based on your first equation, are you actually saying, IF C23 is NOT blank, OR, if C23 and C24 are blank, then K42. If this is the case, then one way of writing it would be:
    =IF(AND(C23="",C24=""),K42,IF(C23<>"",K42,""))

  3. #3
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2016
    Posts
    5,908

    Re: Please Combine these 2 formulas, the work individually but not together.

    Maybe?

    =IF(C24&C23="",K42,IF(C23="","",K42))
    Last edited by Phuocam; 02-09-2020 at 12:53 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Macro works from call command, but does not work when run individually?
    By grinningscott in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-04-2018, 11:16 PM
  2. Combine Two Macros so they Work Together
    By HangMan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-18-2015, 02:32 PM
  3. Combine Two Macros so they Work Together
    By HangMan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-18-2015, 11:50 AM
  4. [SOLVED] Using Combine macro to combine multiple worksheets - need to modify to paste formulas
    By DLSmith in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-26-2012, 09:07 AM
  5. Replies: 2
    Last Post: 03-05-2012, 06:06 PM
  6. Copy rows from work sheets to combine to one work sheet based on cell value
    By joemcmillen in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-11-2008, 05:04 PM
  7. [SOLVED] Combine Work Sheets
    By JR in forum Excel General
    Replies: 2
    Last Post: 02-16-2006, 04:45 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1