View Single Post
 
Old 06-02-2022, 10:19 AM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2019
Expert
 
Join Date: Apr 2014
Posts: 871
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default

Office365 lets you do this; the formula
=sales.value/sales.Volume
in cell C14 will spill the results down to cell C19.


With earlier versions you should be able to select cells C14 to C19 and type in the same formula, but commit the formula to the whole selected range using Ctrl+Shift+Enter rather than the usual plain Enter. (I haven't checked this.)
Reply With Quote