If condition: help needed

[DocAElstein]

Hi lome,

I am not sure if I have the logic correct of what you want.
I find it helpful to put theses things clearly into words
This is what I understand…
A formula is wanted in a cell subscriptions worksheet
A payment is made in cell G6 worksheet payment from a "single" or "couple" member, ( - 35 for a Month was your example - cell G6 in worksheet payment has 35 put in it ). It could come from a single or couple Member.
If single or couple is shown:
In subscriptions worksheet column E - ( E6 in the example ) I may have “single” or “couple” .
Then your logic.. The model I have has three tabs; Payments, Subscriptions and donations. Members who are singles contribute £5 a month and couples contribute £10, but sometimes members contribute less than their monthly subscriptions. However, sometimes members pay their subscriptions together with donations. I want a formula in the subscriptions tab that is able to split the subscription amount from donation and ensure that the amount for a couple or single is entered even if the amount paid is less than the required subscription.
E.g. a member who is single paid £35 in a month. This is entered against the member in the payments tab. I want a formula in the subscriptions tab to take only £5 as subscriptions against that member and the donations tab to take the rest. Where a member pays less than the required subscription, the full amount is entered as subscriptions.
I only need to check for single: If I do not have single then I assume I have couple.

So my logic:
If ( Single then ; ____ ; Else _____ )
____ will be case single
_____ will be case couple

____ and _____ will be very similar according to your logic, differing only by
____ having a 5 in it
_____ having a 10 in it

=IF(E6="single",IF(Payments!G6<=5,Payments!G6,5),IF(Payments!G6<=10,Payments!G6,10))

Worksheet: Subscriptions

If I have not got it right, then can you upload two workbooks, with just a small amount of data. Desensitise the data ( make names up etc.. but pick the data carefully so that it demonstrates typical scenarios. )

One file should be the “Before” - so what you have before you enter any payment.

The “after” should be hand filled in by you to show what you want the formula to do, that is to say what results you want to have. And say what you will be wanting to be doing to get those results.

Alan

[lome53]

Hi lome,

I am not sure if I have the logic correct of what you want.
I find it helpful to put theses things clearly into words
This is what I understand…
A formula is wanted in subscriptions
In subscriptions column E I may have “single” or “couple” .
I only need to check for single: If I do not have single then I assume I have couple.

So my logic:
If Single then ____ ; Else _____
____ will be case single
_____ will be case couple

____ and _____ will be very similar, differing only by
____ having a 5 in it
_____ having a 10 in it

=IF(E6="single",IF(Payments!G6<=5,Payments!G6,5),IF(Payments!G6<=10,Payments!G6,10))

Worksheet: Subscriptions

If I have not got it right, then can you upload two workbooks, with just a small amount of data. Desensitise the data ( make names up etc.. but pick the data carefully so that it demonstrates typical scenarios. )

One file should be the “Before” - so what you have before you enter any payment.

The “after” should be hand filled in by you to show what you want the formula to do, that is to say what results you want to have. And say what you will be wanting to be doing to get those results.

Alan

Alan,

Thanks for looking at this post. I forgot to mention that when a member's status is not know, column E is left blank and the assumption in subscriptions is that the member is single. So you can have single, couple or blank in column E, but when blank, the formula in subscriptions assumes single and allocate £5. Sample Model.xlsx

I used insert Image as I cannot see an option to upload file

In the file:

Row4 where there was no payment
Row5 where member is a couple and paid subs with donation
Row6 where member is single and paid less than required subs

Thanks once again