exceed

Hi, Appologies if this is long winded but it seemed the easiest way to explain myself. I need to create a solution to break the following table up into multiple, 2 part sections A&B. The total quanity of each section must be divisable by 15. Neither section can exceed 45,270 and the sum of...

=SUMPRODUCT(--(YEAR(B2:B589)=2017)) =SUMPRODUCT(--(YEAR(B2:B589)=2018)) =SUMPRODUCT(--(YEAR(B2:B589)=2019)) I am using the code above to count based on a date in a continually expanding table. If i expand the range beyond B589 it returns #VALUE regardless of data that is in the table and I'm...

Please help with a formula I'm trying to work out. I'm trying to return a 'Pass' or 'Fail result based on the following. My criteria is below. A = Loan + Interest B = Loan to Value (%) inc Interest C = Max Loan @ 75% (£750,000) D = Max Loan @ 70% (£1,000,000) E = Max LTV 75% F = Max LTV...

I have to show RAG status for the following in a 200 row document. How do I set up my formual Green - no users exceed 95% of 1GB limit Amber - Site does not have users that exceed 1GB, but does have users over 95% of 1GB Red - Site does have users who presently exceed the 1GB...

The below if statement works fine: =IF(OR(A3={"D","V","X","GE","SR","VP"}),IF(AND(H9+I12>200),"FEES - can exceed $200.00","")) When I add an additional IF, when the condition is met, the results do not appear. The first IF still displays the proper result...

Given a list of 20 numbers between 65 and 100. Anything less than 70 = Fail (F); between 70 - 93 = Pass (P); and anything over 93 = exceed (E). What is a formula that I can use to derive results.

Ladies and gentlemen, I am trying to compare a value ( say C80 ) and figure out how many cells it takes to exceed a value ( say -2 ) in a column ( say E79:E2 ) but then actually stopping the count after that first cell count has been triggered. I'm in a bind - any help would be highly...