![]() |
|
#1
|
|||
|
|||
![]() In cell f3 I have a #, in cells g3 thru L3 I have the below...is there an easier way to enter the formula instead of in each cell? Again I am incrementing by 5's by referencing the cell f3 =F3*5, =f3*10, =f3*15.. |
#2
|
|||
|
|||
![]()
SubscribersSMS texts per yr (5 texts per outage, 2 outages per yr)SMS texts per yr (5 texts per outage, 3 outages per yr)SMS texts per yr (5 texts per outage, 4 outages per yr)SMS texts per yr (5 texts per outage, 5 outages per yr)105,0001,050,0001,575,0002,100,0002,625,000
using the subs I am using =F10*5, =f10*15, =f10*20, etc is there a way instead of manually changing the *5, *10,*15 I can just enter a formula to reference that I am using timesing by 5's?? sorry can u tell i am new |
#3
|
||||
|
||||
![]()
In G3 enter
Code:
=$F$3*5*(column()-6)
__________________
Using O365 v2503 - 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 |
![]() |
Tags |
help please |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
aligahk06 | Word | 1 | 08-28-2010 03:41 AM |
Creating multiply word documents | Michel777 | Word | 0 | 04-26-2010 05:00 AM |