View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Igneshwara reddy[_2_] Igneshwara reddy[_2_] is offline
external usenet poster
 
Posts: 68
Default repeating the answer in A2 cell to A3:A20

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.