All the cells A3:A20 should be linked to A2 cell, if there is any changes
again it should take.

Regards,
Igneshwara Reddy

"T. Valko" wrote:

Enter the formula like this in A2:

=IF(A$1=500,"Correct","Check")

Copy down to A20


--
Biff
Microsoft Excel MVP


"Igneshwara reddy" wrote in
message ...
Hi,

A1 = 500
A2 = If(A1=500,"Correct","Check")
Based on the answer it is shown up in A2 cell (Correct), the same answer
should automatically show up in all the cells from A3:A20.

Please let me know if any formual would assist here.

Regards,
Igneshwara Reddy.