Posted to microsoft.public.excel.worksheet.functions

Igneshwara reddy[_2_] Igneshwara reddy[_2_] is offline

external usenet poster

Posts: 68

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.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Calculator Answer Doesn't Match Excel Answer	GwenH	Excel Discussion (Misc queries)	3	October 20th 08 10:17 AM
Repeating numbers in same cell	Tabby	Excel Worksheet Functions	9	April 5th 08 02:38 PM
Update Excel cell in formula not refreshing answer cell	Johnny	Excel Discussion (Misc queries)	2	June 21st 07 05:49 AM
Repeating a Cell	Diana	Excel Worksheet Functions	3	January 20th 06 09:41 PM
Repeating same task for different cell	Tan Arthur via OfficeKB.com	New Users to Excel	3	December 9th 04 01:02 PM

All times are GMT +1. The time now is 10:00 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us