+ Reply to Thread
Results 1 to 14 of 14

Cell results based off multiple other cell output

  1. #1
    Registered User
    Join Date
    06-27-2014
    Location
    Indiana
    MS-Off Ver
    2007
    Posts
    24

    Cell results based off multiple other cell output

    I am trying to get Cells Q,S,U,W,Y,AA & AC (in the example photo) to read "PAID" or "DUE" based on information from other cells.

    I have been able to get it all to work except 1 issue...... I want the "PAID" to show if the balance is equal or over cell "K" no matter if the cell beside it is blank or not. I want the "DUE" to not show at all if the payment cell beside it is empty.

    This is the argument I have: I just need to get the "PAID" to show in cell "S".

    In this example, the formula that is in "S" is:
    =IF(R6="","",IF(OR($K$6<=0,$K$6=""),"",IF($K$6>=R3,"PAID",IF(OR($K$6<=R3,$K$6>0),"DUE",""))))

    the formula that is in U,W,Y,AA & AC is:
    =IF(OR($K$6<=0,$K$6=""),"",IF($K$6>=T3,"PAID",IF(OR($K$6<=T3,$K$6>0),"DUE","")))


    Thank you,
    Last edited by LShepherd; 09-17-2016 at 12:42 PM.

  2. #2
    Forum Expert gmr4evr1's Avatar
    Join Date
    11-24-2014
    Location
    Texas
    MS-Off Ver
    Office 2010 and 2007
    Posts
    3,448

    Re: Cell results based off multiple other cell output

    Some of us are unable to see images posted here. Can you attach a sample workbook with formulas in it.
    1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
    You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.

    Tom

  3. #3
    Registered User
    Join Date
    06-27-2014
    Location
    Indiana
    MS-Off Ver
    2007
    Posts
    24

    Re: Cell results based off multiple other cell output

    Would love to, but when I try to add a file, I get a blank drop down menu.... so don't have the ability too unless Im over looking something

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,002

    Re: Cell results based off multiple other cell output

    Make sure there is enough data to demonstrate your need. Make sure your desired results are shown, mock them up manually if necessary. Remember to remove ALL confidential information first!!!

    However, nothing on this Forum works quite as well as you might expect. The attachment icon doesn't work!! (Helpful, isn't it!!). Instead, just before you submit your post, click on GO ADVANCED (near the bottom) and then scroll down to Manage Attachments to open the upload window. The relevant instructions are at the top of that screen.
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  5. #5
    Forum Expert gmr4evr1's Avatar
    Join Date
    11-24-2014
    Location
    Texas
    MS-Off Ver
    Office 2010 and 2007
    Posts
    3,448

    Re: Cell results based off multiple other cell output

    You can also click the Insert Image icon (1 to the left of the Quote icon) to bring up an upload window.

  6. #6
    Registered User
    Join Date
    06-27-2014
    Location
    Indiana
    MS-Off Ver
    2007
    Posts
    24

    Re: Cell results based off multiple other cell output

    I think this will work? Here is the excel sheet

    http://www.excelforum.com/attachment...1&d=1474127951
    Attached Files Attached Files

  7. #7
    Registered User
    Join Date
    06-27-2014
    Location
    Indiana
    MS-Off Ver
    2007
    Posts
    24

    Re: Cell results based off multiple other cell output

    Sorry it doubled my reply

  8. #8
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,002

    Re: Cell results based off multiple other cell output

    A bit confused... but is this it?

    =IF($K6>=P$3,"Paid",IF(P6="","","Due"))

    copied down and across, as needed

  9. #9
    Registered User
    Join Date
    06-27-2014
    Location
    Indiana
    MS-Off Ver
    2007
    Posts
    24

    Re: Cell results based off multiple other cell output

    Clean working arguement in cell Q6 is

    =IF(OR(K6<=0,K6=""),"",IF(K6>=$P$3,"PAID",IF(OR(K6<=$P$3,K6>0),"DUE","")))

    Copied down and over (yes) but what I want to add is a rule that if the cell Z6 (for example) is blank and AA6 reads "Due" then the "Due" doesn't appear, but if it reads "PAID" it will remain.

  10. #10
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,002

    Re: Cell results based off multiple other cell output

    Try this.

    If it's not right, tell me WHY it's not right.

    =IF(OR($K6<=0,$K6=""),"",IF($K6>=P$3,"Paid",IF(P6="","","Due")))

  11. #11
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,002

    Re: Cell results based off multiple other cell output

    see file and, in particular AB6 and AC6.
    Attached Files Attached Files

  12. #12
    Registered User
    Join Date
    06-27-2014
    Location
    Indiana
    MS-Off Ver
    2007
    Posts
    24

    Re: Cell results based off multiple other cell output

    Placing your argument into cell "S6"
    =IF(OR($K6<=0,$K6=""),"",IF($K6>=P$3,"Paid",IF(P6="","","Due")))

    didn't work cause it was still referring to the P6 cell, but changing it over to:

    =IF(OR($K6<=0,$K6=""),"",IF($K6>=R$3,"Paid",IF(R6="","","Due")))

    Worked perfectly!! Thank you so much!!

  13. #13
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,002

    Re: Cell results based off multiple other cell output

    How were you entering it into S6? The absence of $ signs around P6 means that when you copy/paste across 2 columns it will (should!!) then refer to the column immediately to its left...

  14. #14
    Registered User
    Join Date
    06-27-2014
    Location
    Indiana
    MS-Off Ver
    2007
    Posts
    24

    Re: Cell results based off multiple other cell output

    Copying and pasting the code wasn't my issue. I know how to do that. I just wasn't able to get the PAID to stay and the DUE to leave if the cell to the left was blank, but the amount paid was high enough to say they had paid for the week. I WAS using the argument:

    OLD: =IF(OR(K6<=0,K6=""),"",IF(K6>=$P$3,"PAID",IF(OR(K6<=$P$3,K6>0),"DUE","")))

    NEW =IF(OR($K6<=0,$K6=""),"",IF($K6>=R$3,"Paid",IF(R6="","","Due")))

+ 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. Color Cell Based on Specific Text in Other Cell and Sorting Based on Results
    By kre30a in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-24-2016, 07:51 PM
  2. Compare values and output cell titles, able to output multiple results
    By TMG2016 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 05-07-2016, 11:42 AM
  3. [SOLVED] Autofill a cell based on results of multiple dynamic drop down lists
    By jmp764 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-26-2014, 05:51 AM
  4. Search cell text and output different values based on result in another cell
    By tbarn1980 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-14-2013, 09:54 PM
  5. [SOLVED] Return output from written results in different cell
    By jana135 in forum Excel General
    Replies: 6
    Last Post: 07-03-2012, 03:12 AM
  6. Return output from written results in different cell
    By jana135 in forum Excel General
    Replies: 1
    Last Post: 07-03-2012, 12:55 AM
  7. Replies: 0
    Last Post: 08-01-2011, 09:00 AM

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