Results 1 to 5 of 5

Help with an array Formula to Compare, Sum, then Multiply result by a Constant

Threaded View

  1. #1
    Registered User
    Join Date
    01-06-2016
    Location
    Tampa, FL
    MS-Off Ver
    2010
    Posts
    2

    Help with an array Formula to Compare, Sum, then Multiply result by a Constant

    I'm hoping someone may be able to help a newbie with an array problem I'm having.

    Column A has various values. Column B has various values. Cell C1 has 100 as the value.

    I need an array that multiples cell A1 * B1 to check to see if that value is > 0. Then multiples A2 * B2 to check if that is > 0 and so on through the end of the array. If any of those calculations yield a result that is > 0, then the array will take the result for each individual calculation and, if it is true, multiply the value in Column B by the value cell C1.

    For example:
    A1 = 10
    A2 = 0
    A3 = 15


    B1 = 2
    B2 = 3
    B3 = 1


    C1 = 100

    The result of this should be 300 calculated as:

    A1*B1>0 so B1 * C1 = 200
    A2*B2=0 so do nothing
    A3*B3>0 so B3 * C1 = 100

    The result is 300. I need this result represented in a single cell. Can anyone help?

    Thank you!

    Troy

    http://www.excelforum.com/excel-general/1120335-help-with-an-array-formula-to-compare-sum-then-multiply-result-by-a-constant.html
    Last edited by prostyles; 01-06-2016 at 02:30 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Headache with formula
    By crazytimechris in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-07-2015, 10:25 AM
  2. [SOLVED] Array formula headache
    By SamoRn12 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-17-2015, 01:28 PM
  3. [SOLVED] Multiple if/or formula headache; please help!
    By pembr0ke in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-09-2015, 11:12 AM
  4. GETPIVOTDATA - giving me a major headache
    By custom63willys in forum Excel Charting & Pivots
    Replies: 15
    Last Post: 09-20-2012, 05:44 PM
  5. Average function giving me a headache
    By ggutier49 in forum Excel General
    Replies: 3
    Last Post: 02-04-2009, 03:10 PM
  6. Formula headache!
    By JoeyG in forum Excel General
    Replies: 0
    Last Post: 04-03-2007, 04:18 PM
  7. Cure my array headache!
    By grime in forum Excel General
    Replies: 7
    Last Post: 07-27-2005, 03:38 PM

Tags for this Thread

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