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