Results 1 to 2 of 2

Sales pipeline formulas - if and then

Threaded View

  1. #1
    Registered User
    Join Date
    01-24-2019
    Location
    Dubai, UAE
    MS-Off Ver
    Office 365
    Posts
    1

    Sales pipeline formulas - if and then

    Hi all,

    Newbie in this forum.

    I am building a sales pipeline where I have two types of charges: 1- one off charges , 2 - monthly recurring charges.

    Using the below formula allows me to match the month of the expected sale in order to spread the monthly recurring charges over the 12 month period, however, if I have a one off charge, how do I add it in the formula? See attached pic as i couldn't upload any files for some reason.

    Example:
    test.JPG

    =IF(F3>0,F3,(IF(MONTH(G$2)=MONTH($C3),$E3,0)))

    thanks in advance.
    Attached Files Attached Files
    Last edited by sneakybear; 01-24-2019 at 03:00 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Sales pipeline- Dividing money across months
    By tfboland in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-21-2013, 05:08 PM
  2. Need some help with a sales pipeline report
    By tonycanevaro in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 08-13-2012, 04:02 PM
  3. Sales Pipeline
    By birdoo2 in forum Excel General
    Replies: 7
    Last Post: 07-14-2009, 06:14 PM
  4. [SOLVED] how do I customize product sales pipeline management template
    By Cine-tal in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 10:05 AM
  5. [SOLVED] how do I customize product sales pipeline management template
    By Cine-tal in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 06:05 AM
  6. [SOLVED] how do I customize product sales pipeline management template
    By Cine-tal in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 AM
  7. [SOLVED] how do I customize product sales pipeline management template
    By Cine-tal in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 01:05 AM
  8. [SOLVED] how do I set up a sales pipeline spreadsheet?
    By DrTimBoone in forum Excel General
    Replies: 1
    Last Post: 05-19-2005, 08:06 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