Excel - greater than value from a range + an additional if

[rizzstang]

Hi = I've been fumbling around and cannot figure this out. If someone can help, I would really appreciate it.

Cell A1= If any % in a moving list (Column M; i.e. the top number will be abs val'd and the list will grow as we pull down) is greater than 50%, then a cell is multiplied by 10%...
if any of the numbers in the list are less than or greater to 50%, then there's one more "if" statement based on this being correct (i.e. one of the %s in the list are less than 50%). If there's a % in the list less than 50% then the test is whether the % in the current row/cell (not the full list) is < or > 50%. If the current cell is >50%, then a cell is multiplied by 10% or if the current cell is <50% then a cell is multiplied by 25%.

a doozy for me at least
Thank you!!

 

[Cubist]

Cell A1= If any % in a moving list (Column M; i.e. the top number will be abs val'd and the list will grow as we pull down) is greater than 50%, then a cell is multiplied by 10%...
if any of the numbers in the list are less than or greater to 50% then there's one more "if"

Hi,
You have some repeated conditions so your requirements are unclear. It'd be helpful if you could show a few different scenarios (5-10 rows) for each scenario of the expected result.

 

[rizzstang]

Thanks @Cubist for offering to help! I'm not sure if this picture is clear. let me know if I should try again. Basically there's a trigger once the LTV hits 50%. Before that point it's easy and the formula is simple. But once the 50% LTV happens (in May) then there will be two subsequent formulas depending on the LTV.

In short, once May/50%LTV happens all bets are off and the two new formulas kick in

LTV - Loan-to-Value in case you were wondering...thanks for giving it a shot!!
note: I changed the percentages...they're arbitrary as the ones I'm working with are rather precise.
If I need to do this in a few columns, that's fine too.

 

[Cubist]

Try:

Book1
	A					F	G			J	K
1	Coverage Period					Value	LTV			Multiplier	Result
2	January					10	85%			35%	3.5
3	February					12	75%			35%	4.2
4	March					14	60%			35%	4.9
5	April					16	51%			35%	5.6
6	May					18	49%			10%	1.8
7	June					20	40%			10%	2
8	July					22	60%			50%	11
9	August					24	55%			50%	12
10	September					26	35%			10%	2.6
11	October					28	25%			10%	2.8
Sheet1

Cell Formulas
Range	Formula
J2:J11	J2	=IF(COUNTIF($G$2:G2,"<50%")<1,35%,IF(G2<50%,10%,50%))
K2:K11	K2	=F2*J2
F3:F11	F3	=F2+2