+ Reply to Thread
Results 1 to 2 of 2

Trying to create a series of IF functions without being redundant, NEED Help

  1. #1
    Registered User
    Join Date
    09-25-2014
    Location
    Delaware, USA
    MS-Off Ver
    MS Office 2015
    Posts
    1

    Trying to create a series of IF functions without being redundant, NEED Help

    So I want to be able to input dollar amounts with either a v,m,d, or a in the cell next to them (representing visa, mastercard, discover and amex) and have a function sum the values for each corresponding credit card. The trouble i've encountered is trying to display the information without being redundant.

    so far I have:
    =IF(G19>0,"ROA VISA - "&G19,IF(H19>0,"ROA MASTERCARD - "&H19,IF(I19>0,"ROA DISCOVER - "&I19,IF(J19>0,"ROA AMEX - "&J19, " "))))
    =IF(H19>0,"ROA MASTERCARD - "&H19,IF(I19>0,"ROA DISCOVER - "&I19,IF(J19>0,"ROA AMEX - "&J19, " ")))
    =IF(I19>0,"ROA DISCOVER - "&I19,IF(J19>0,"ROA AMEX - "&J19, " "))
    =IF(J19>0,"ROA AMEX - "&J19, " ")

    If the data does not have all 4 types of cards then my output lines will list the same information twice.

    i.e.

    ROA MASTERCARD - X
    ROA MASTERCARD - X
    ROA DISCOVER - Y
    ROA AMEX - Z

    Basically, how do I tell it to not be redundant.

  2. #2
    Forum Expert ben_hensel's Avatar
    Join Date
    01-26-2012
    Location
    Northeast USA
    MS-Off Ver
    Office 365
    Posts
    2,043

    Re: Trying to create a series of IF functions without being redundant, NEED Help

    Why even use IFs?

    Just have all four cards listed and display the total next to it, in a simple 2x4 output table.

+ 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. Need Help with Dynamic Graph Creation using the Series and Offset Functions
    By MFried99 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-09-2014, 09:51 AM
  2. [SOLVED] Create number series based on another number series
    By hbangalore in forum Excel General
    Replies: 8
    Last Post: 04-05-2012, 01:22 PM
  3. Chart script functions, but adds unnecessary series.
    By jordan.mcleod in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-24-2012, 12:29 PM
  4. 2 IF functions and remove bottom 2 cells from a series total
    By baker2gs in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-19-2012, 12:06 AM
  5. Add Quantity of Redundant Rows, then Delete Redundant Rows
    By alexwgordon in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-04-2012, 12:12 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