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..

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

In G3 enter and drag as needed

__________________
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