Question about PRODUCT function and dollar sign

[katzelmacher]

Hey,

I have a table with different employees, each one receives a different amount of money per hour. Row A is formed by employees names, row 2 has the salary they get below the name. On column B I will enter the number of hours worked. How can I do that automatically?

Example:
Column C = Employee Jack; C2 = $15
Column D = Employee Jane; D2 = $16
Row 3 = Hours worked in March; B3 = 15
Row 4 = Hours worked in April; B4 = 17


C3 = PRODUCT(C2,B3) = 15*15 = 225; D3 =PRODUCT(D2,B3) = 16*15 = 240; C4 =PRODUCT(C2,B4) = 15*17 = 255

I cannot use the dollar sign to fix a column but so far no luck, could you experts please assist me? Thank you!

[benishiryo]

hi katzelmacher. you could use:
=PRODUCT(C$2,$B3)

or just:
=C$2*$B3

do mark the thread as Solved if that answers your question