Spreadsheet division by a constant


column d 176 rows deep. in column e want divide each no. in d 52. steps?

 

in e1 (or e2 if first row header), write =d1/52 (or d2 if first row header)
copy , paste e1 (e2) remaining cells in column e

these work in excel, not sure spreadsheet using.
 


Forums Macs Mac Basics and Help


  • iPhone
  • Mac OS & System Software
  • iPad
  • Apple Watch
  • Notebooks
  • iTunes
  • Apple ID
  • iCloud
  • Desktop Computers
  • Apple Music
  • Professional Applications
  • iPod
  • iWork
  • Apple TV
  • iLife
  • Wireless

Comments

Popular posts from this blog

Upgrade Eligibility?

need help with itunes 7.7

How to change Apple IDs on iPhones