| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Populate one cell with specific figure
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Populate one cell with specific figure
=IF(A1="","",118+(A1-4)*33)
-- Gary''s Student - gsnu200737 "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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Populate one cell with specific figure | Excel Discussion (Misc queries) | |||
| Use a code to populate a cell with a specific value | Excel Worksheet Functions | |||
| Link from a specific Cell in Excel to a specific para. in Word | Excel Worksheet Functions | |||
| Cells populate on specific dates | Excel Worksheet Functions | |||
| When I select from drop down menu I would like the next column to populate a specific cost. | Excel Worksheet Functions | |||
Hybrid Mode
