build a formula if

[Roy5683]

How do I build a formula IF A1>=1 AND A1<=20 THEN A4=A3

 

[Joe4]

You have asked three very similar questions on IF statements. Are you doing a homework assignment or something?

Are you taking the time to try to understand how IF statement work?

Take a crack at it yourself, and see if you can come up with the answer.

 

[anandvarma]

please follow the suggestion of Joe 4

try this

Excel Workbook
	A
1	20
2
3	25
4	25
Sheet2