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)

 

Thanks! 

 

excel
  • Lorenzo's avatar
    Lorenzo
    Silver Contributor
    Jan 10, 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

     

Resources