Forum Discussion

Benscroggs's avatar
Benscroggs
Copper Contributor
Jan 09, 2024

Formula Question

Hello,    What formula would I use to change the values in B1:K1 when entering a different whole number in cell A1?  Ex (if 2 is entered in A1, I would need the values from B1:K1 to double)   Th...
excel
Lorenzo's avatar
Lorenzo
Silver Contributor
Jan 09, 2024

Hi Benscroggs 

 

Alternatively

  • Enter your values in B1:K1
  • Hide row #1
  • In B2 enter formula (and copy it right until K2):
=$A2 * B1

and instead of entering 2 (or whatever number) in A1, enter it in A2