simple formula

[rhr9357]

if value in cell # b64 is greater than 2000 but less than 4000 then enter the value of cell c64

 

[VoG]

Try

=IF(AND(B64>2000,B64<4000),C64,"")

 

[Weaver]

Hello and welcome to the board.

=if(and(b64>2000,b64<4000),c64,"")

You didn't specify what the result should be if the condition fails so I've used a null string to keep the cell effectively blank

 

[texasalynn]

Excel Workbook
	B	C	D
64	2500	10	10
Sheet1

Excel 2003

Cell Formulas
Range	Formula
D64	=IF(AND(B64>2000,B64<4000),C64,0)