+ Reply to Thread
Results 1 to 8 of 8

If Funcation help

  1. #1
    Registered User
    Join Date
    04-04-2014
    Location
    India,Pune
    MS-Off Ver
    Excel 2013
    Posts
    95

    If Funcation help

    Hi,

    Sorry i reposted threads because last threads i have wrongly mark as solved.

    Can anyone please go through my request and provide me solution.

    Sorry for inconvenience.

    http://www.excelforum.com/excel-gene...condition.html
    1) IF my total invoice (Column F) is $100 and i have received partial payment (Column G) $50 then as per days $50 comes under in between column I to L.

    2) If i have received full payment (Column G) on 0 to 90 days then the payment amount comes under in between column I to L.

    3) IF i have not received any payment then Total invoice (Column F) amount will comes under in between column I to L as per days outstanding.


    I hope you understand my question.

    Thanks
    Attached Files Attached Files
    Last edited by rchure; 06-10-2014 at 08:09 AM.

  2. #2
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    28,212

    Re: If Funcation help

    Does the attached help?
    Attached Files Attached Files
    Richard Buttrey

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    04-04-2014
    Location
    India,Pune
    MS-Off Ver
    Excel 2013
    Posts
    95

    Re: If Funcation help

    Hi Richard,

    Thanks for reply...

    Only one issue if i have received full payment "Column G" then its amount shows under column I to L which days is fulfil.

    Ex- suppose i have received payment on 20 days then payment amount (Column G) shows under "column I" resp.

    I hope you understand my query.

    Thanks

  4. #4
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    28,212

    Re: If Funcation help

    Sorry but I just don't see that.

    Enter a full payment of 44211 in G7 and there is no analysis in columns I:L.

    Can you clarify please.

  5. #5
    Registered User
    Join Date
    04-04-2014
    Location
    India,Pune
    MS-Off Ver
    Excel 2013
    Posts
    95

    Re: If Funcation help

    Hi,

    Actually we want to also see that after how many days we recevied full payment.

    so in columns I:L we can find recevied payment amount days.

    let me know if you have any other questions

    Thanks

  6. #6
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    28,212

    Re: If Funcation help

    Sorry but I still don't understand.

    Are you saying that columns I:L contain numbers of days NOT currency values?

    Please add several example lines and manually add the results you expect to see.

  7. #7
    Registered User
    Join Date
    04-04-2014
    Location
    India,Pune
    MS-Off Ver
    Excel 2013
    Posts
    95

    Re: If Funcation help

    Sorry for confusing you.

    I will disucss the sheet which you provided with my colleague and let you know if any changes required.

    I will reply you on monday.

    Thanks for your time any help..

  8. #8
    Registered User
    Join Date
    04-04-2014
    Location
    India,Pune
    MS-Off Ver
    Excel 2013
    Posts
    95

    Re: If Funcation help

    Hi Rich,

    I have confirm with my colleague no changes required for above formula.

    Thanks for your help..

+ 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. [SOLVED] can i use if with mod and vlookup funcation in the same funcation or not
    By hazemrezo in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-26-2013, 04:06 PM
  2. IF funcation (maybe???)???
    By burnsie in forum Excel General
    Replies: 3
    Last Post: 09-22-2009, 06:28 AM
  3. funcation
    By CLR in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-06-2005, 03:05 PM
  4. [SOLVED] funcation
    By wassim in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 PM
  5. [SOLVED] funcation
    By wassim in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 10:05 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