Results 1 to 5 of 5

Breakup of MMULT-Transpose function with addition of condition in existing formula

Threaded View

  1. #1
    Forum Contributor
    Join Date
    03-11-2011
    Location
    Nepal
    MS-Off Ver
    MS Excel 2024
    Posts
    1,384

    Breakup of MMULT-Transpose function with addition of condition in existing formula

    Hi,
    Can you explain & elaborate the breakup of the formula that is in the 2nd sheet in C20:F23.Besides this I want further to add a condition which is in Column F,that if the sales Quantity>= Column F,then Scheme would be given,otherwise result is zero or blank.

    With Best Rgds,
    Suresh
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. MMULT(A1:B2;TRANSPOSE(A3:B3))
    By sensorflo@gmail.com in forum Excel General
    Replies: 6
    Last Post: 02-16-2017, 02:17 AM
  2. Adding an IF condition into an existing formula.
    By dmejia174 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-06-2013, 07:33 PM
  3. [SOLVED] How to add another IF condition in an existing formula. Please help
    By dmejia174 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-06-2013, 06:04 PM
  4. Adding condition to existing formula
    By KINNEY0201 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 09-16-2010, 01:42 PM
  5. Amend formula to include addition condition
    By Pat in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-16-2005, 12:06 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