school project ..please help

S

sally

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 ...
 
D

Don Guillett

or
=IF(G3="","",CONVERT(G3,"C","F"))
CONVERT
See Also

Converts a number from one measurement system to another. For example,
CONVERT can translate a table of distances in miles to a table of distances
in kilometers.

If this function is not available, and returns the #NAME? error, install and
load the Analysis ToolPak add-in.

How?

1.. On the Tools menu, click Add-Ins.
2.. In the Add-Ins available list, select the Analysis ToolPak box, and
then click OK.
3.. If necessary, follow the instructions in the setup program.
Syntax

CONVERT(number,from_unit,to_unit)

Number is the value in from_units to convert.

From_unit is the units for number.

To_unit is the units for the result. CONVERT accepts the following text
values (in quotation marks) for from_unit and to_unit.
 
Top