View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Toppers
 
Posts: n/a
Default school project ..please help

In the column(s) for your F degrees:

=(C1*1.8)+32 assuming C1 is the degrees C

Copy this formula down to row 190.

HTH

"sally" wrote:

hi everyone I want to write a sub that converts all values of two
consecutive columns(C1:D190) from c degree to f degree.I know the
formula but don't know how to apply it to all cells I'm completely
confused .This is part of my school project and I don't know how to do
it. please help ...