LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 47
Default enter a number if equal to another number

hi

i have a worksheet number in cell A eg 6 and a number in cell B1 eg 100, i
want to have the number 100 in cell B2 to B5 automatically, the number in
cell A is always a single digit number but in cell B it is always two or
three digit number. can i do this? thanks
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
number range to equal one value. Chuckles Excel Worksheet Functions 5 December 15th 07 03:52 AM
Is there formulas which set text to equal a number? Barbara S Excel Worksheet Functions 1 October 5th 07 06:03 PM
Cell can only equal Whole Number TriFiV Excel Discussion (Misc queries) 2 June 18th 06 09:53 PM
first number in a column not equal to zero James Fullmer New Users to Excel 4 June 10th 06 07:36 AM
IF statement, can it equal more than one number? PhilGTI Excel Worksheet Functions 3 February 16th 05 12:06 AM


All times are GMT +1. The time now is 07:32 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"