#1
|
|||
|
|||
Help with increasing multiplier in adjoing cells
I need adjoining cells in a row of my spreadsheet do the following $c$12*14 $c$12*15 $c$12*16 etc (increasing the multiplier by 1 each time) I would be very grateful if someone could help me please. Thank you |
#2
|
||||
|
||||
Hi
supposing you start in A1 try =$c$12*((column()-1)+14) and drag right
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
Thank you so much Pecoflyer - that works perfectly.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Add increasing number at document opening | HidExp | Word | 6 | 09-17-2012 12:28 AM |
cheat(increasing) word count | akbareshghi | Word | 2 | 04-03-2012 10:29 AM |
Page Count Increasing Exponentially | BobF | Word | 3 | 03-23-2012 12:20 PM |
increasing envelope address window | seemore | Mail Merge | 0 | 02-14-2011 12:18 PM |
Count range cells eliminating merge cells | danbenedek | Excel | 0 | 06-15-2010 12:40 AM |