Help in IF condition

**rchure** · 06-06-2014, 06:55 AM

Hi,

Can anyone help me for IF condition in attached sheet column I to L.

I want below condition in column I to L:

1. If I have received payment before 30 days then column (I to L) will be blank.
2. If have received partial payment then remaining amount will be show under the column (I to L) which days is fulfill. Ex-if I have received payment
in between 30 to 60 days then amount comes under Column “J”resp.
3. Amount only comes under column (I to L) when its fulfil it days. Ex- if payment not received till 40 days then it’s come under column “J” resp.

Thanks in advance.

**Punnam** · 06-06-2014, 07:27 AM

Hi ,

Find the attached sheet for your reference in case of any correction let me know.

Punnam

**rchure** · 06-06-2014, 08:11 AM

Hi Punnam,

Thank you very much its work perfectly.

**Punnam** · 06-06-2014, 08:13 AM

Hi Rchure,

welcome u can thank me even by adding me some reputation points .

Punnam

**rchure** · 06-06-2014, 08:16 AM

Hi Punnam,

i don't know about it, can you please tell me how add reputation points?

Thanks

**rchure** · 06-06-2014, 12:28 PM

Hi Punnam,

Sorry i missed the formula you provided it doesn't met my last condition.

Basically i want 3 condition:

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

**Punnam** · 06-07-2014, 10:30 PM

Hi Rchure,

Please provide before and after sheet or enter values manually.so that will be easy for me to understand u r requirement .

Punnam

**rchure** · 06-10-2014, 08:07 AM

Hi Punnam,

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

Thanks for your help..

**Punnam** · 06-10-2014, 11:59 PM

HI Rchure,

Welcome

Punnam

Help in IF condition

LinkBack

Thread Tools

Rate This Thread

Display

Help in IF condition

Re: Help in IF condition

Re: Help in IF condition

Re: Help in IF condition

Re: Help in IF condition

Re: Help in IF condition

Re: Help in IF condition

Re: Help in IF condition

Re: Help in IF condition

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] How to count a condition based on having another condition?

[SOLVED] IF the condition of gender is met AND the condition of age is met subtract this number

[SOLVED] Help for if condition formula result only either hit or miss from mulitple condition

condition decide the range and SUM of the multiple condition

multi condition format? lookup and date condition valid for.

Bookmarks

Bookmarks

Posting Permissions