Modify formula to exclude Paid Fee

Hello, I run a spreadsheet that calculates the total number of valid sales for my photographers. This includes any "No Sales". But currently does not include sales with a deposit of less than 10%. I also wish to exclude anything that is an ancillary fee such as a Booking Fee, Session Deposit, Courier etc. These fall under Paid Fee as a status. I have attached a sample Sales spreadsheet. The final calculation is on a separate tab that references data on the Sales tab.

This is the formula I wrote, that doesn't work. =IF(P2="No Sale",1,IF(O2="Paid Fee",0,IF(AND(G344)>=(F2*10%)),1,"NC"))

The intention is to;
1) Count all No Sales (Invoice Classification column P)
2) Not count any Invoice Status that = Paid Fee
3) Not count any sale where the deposit is less than 10% (columns F/G)

Note that NC represents Not Counted and "1" equals valid.
Formulas have not copied from the original.

Hope this makes sense.

Thx

Hello,

Try this formula and let me know if this works:

=IF(AND(G5>=(F5*10%),P5="No Sale",O5<>"Paid Fee"),1,"NC")

Hi Rick, I can't get this to work. The Paid Fee seems to be the sticking point.

Hi Rick and AliGW,

Sorry if I have confused this.

This is how I see the formula in parts. I am now thinking that maybe each element (not sure the correct term) is OR not And.

=IF(AND(G2>=(F2*10%) If the deposit is less than 10% > NC
,O2="No Sale", If it is a No Sale > 1
O2<>"Paid Fee"),1,"NC") If O2 -Invoice Status = Paid Fee > NC

Does that make sense?

Thanks for you help here. I am now taking a different approach. By modifying the data, I can simplify the process and achieve the required outcome. I appreciate your support very much and I apologise for the confusion and my lack of concise communication. Hopefully I will do a better job next time.

all the very best

North