IF statements

[ValleyQue]

In my spreadsheet I have numbers in three cells. In the first cell, say I have the number 4,000. I need a formula that will look at the number in the second cell and see if the number in the second cell is greater than, less than or equal to 4,000, I need the formula to return only 4,000 or whatever the lesser number may be from the second cell. If the number in the second cells satisfies the 4,000, then I don't need it to look at the third cell, but if the number in the second cell is less than 4,000 then I need the formula to look at the third cell and return either the 4,000 or whatever amount is needed after looking at the second cell to satisfy the 4,000. I know it's a nested IF statement, but I can't figure out how to make it work.

 

[Peter_SSs]

Welcome to the MrExcel board!

See if this is what you want. If not please give 4 or 5 varied examples, the expected results and explain again in relation to your samples.

I suggest that you investigate XL2BB for providing sample data & expected results to make it easier for helpers to understand just what you have & where it is and also what you want & where it is to be.

23 05 13.xlsm
	A	B	C	D	E	F	G	H	I	J	K
1	4000			4000			4000			4000
2	3000	3000		6000	4000		3000	3000		100	100
3	500	500		500	0		2000	1000		2800	2800
ValleyQue

Cell Formulas
Range	Formula
B2,K2,H2,E2	B2	=MIN(A1,A2)
B3,K3,H3,E3	B3	=MIN(A3,A1-B2)

 

[Kerryx]

Question confusing without examples so here is my attempt

Book2
	A	B	C	D
1	4000	2000	3000	2000
Sheet1

Cell Formulas
Range	Formula
D1	D1	=IF(B1<=A1,B1,IF(C1<=A1,C1,A1))