View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Toppers Toppers is offline
external usenet poster
 
Posts: 4,339
Default Populate one cell with specific figure

Try:

A1=4, A2=5 etc

=33*A1-14 and copy down

(Numbers increase by 33?)

But results for 22=712, 23=745

"slavenp" wrote:

I would like to enter a number in one column and populate another column with
a specific number - example: if I enter 4 in one column, then in another
column the figure of 118 would show. The numbers I wish to enter and get an
answer for are from 4 - 23. 4=118, 5=151, 6=184 so on until 22=676 & 23=706.
I have scrolled down the page and put 4-23 in one column and the equivalent
answer next to them in another column. Can YOU help?