Results 1 to 4 of 4

IF Formula, AND/OR

Threaded View

  1. #1
    Spammer
    Join Date
    10-06-2018
    Location
    https://t.me/pump_upp
    MS-Off Ver
    2016
    Posts
    25

    IF Formula, AND/OR

    Hi there

    I have input three formulas in columns F, G, H of the attached workbook named 'Example1', but would like to include them all in just the one formula/column. Possible?

    For completeness, what I am trying to achieve with the result is, if client pays within 35 days they receive 40% share of our commission (column E). More than 35 days they receive 30% share of our commission.

    In calculating the 35 days, it is the Client Paid Date (column A) from the Eff. date (column C), UNLESS the Invoice Date (column B) is greater than the Eff. Date, then it will be Client Paid Date from the Invoice Date.

    Hopefully makes sense, and thanks in advance.
    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. Replies: 3
    Last Post: 01-10-2019, 09:34 AM
  2. Replies: 5
    Last Post: 02-16-2018, 06:50 AM
  3. Replies: 8
    Last Post: 09-22-2017, 05:41 AM
  4. Excel formula bar to display the result of the formula , not the formula?
    By max_max in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-18-2016, 07:15 PM
  5. Replies: 11
    Last Post: 06-06-2014, 03:34 PM
  6. how to hide formula in formula box, view lookup result in formula box?
    By vengatvj in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-14-2013, 04: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