Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

functions

ResolvedVersion 2003

Nikky has attended:
No courses

Functions


I have a row with constant cell figures of

RE: Functions

Hi Nikky,

In new column E, make the cell:
=($A$1*A2)+($B$1*B2)+($C$1*C2)+($D$1*D2)

Then use 'fill down' to copy the formula down to the other rows in the E column.

The dollar signs ($) before the letter and number cell reference indicates the formula should keep the same cell reference each time the formula is copied to another cell. It's called absolute cell referencing.

See also the attached spreadsheet in Excel 2003 format.

Regards, Rich

Attached files...

totals.xls

RE: Functions

Thanks a lot, Nikky

Excel tip:

Convert Text into Number

Some times numbers maybe imported in as text or you maybe concatenating numbers that form a text string that now are treated, because you had to extract them by Text functions

To convert Text into Number just encase the relevant cell reference or formula in the TEXT function. See Converting American Date to European hint

eg TEXT(Ref) or TEXT(formula)

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.