Nest IF And Statements

[DadofFlash]

Hi All,

I'm trying to create nested If And statements to return a calculated value if the value in another cell matches the criteria but my head is mashed trying.

Simply Put I'm trying to create the fiollowing using If(And statements and not getting anywhere.

Example..

Help please.

Thanks,

Dave.

 

[hagia_sofia]

Hello, could you possibly elaborate more on what is the aim and expected output? E.g. is the aim to verify to which interval 72 belongs and return the corresponding number (22) or something else?

 

[DadofFlash]

Thanks for the reply all, A cup of tea and a vape away from the desk has cleared the head and I've managed to get the formulae correct.

Have a great day.

 

[Peter_SSs]

I've managed to get the formulae correct.

Welcome to the MrExcel board!

Something like this?

25 03 07.xlsm
	A	B	C	D
1
2		25	25	72
3	25	50	25
4	50	100	22
5
6
7		25	25	28
8	25	50	3
9	50	100	0
Test

Cell Formulas
Range	Formula
C2:C4	C2	=MIN(B2-A2,D$2-SUM(C$1:C1))
C7:C9	C7	=MIN(B7-A7,D$7-SUM(C$6:C6))