Using text in place of values

  • Thread starter Thread starter Gabe Silverman
  • Start date Start date
G

Gabe Silverman

Hi there - I'm new to Excel but I can't figure out how to use text in
place of numeric values.

I'm building an invoicing worksheet - so one column indicates the
hourly rate, the other lists the amount of time billed at that rate.

So for example, in one column it says "Design" and in the next column
it says 4.00 hrs. Design is billed at $35.00 per hour - so somehow I
need to tell Excel that "Design" = $35.00 and then have it do the
multiplication between the two cells.

Any ideas?

Thanks for your help!

Gabe Silverman
 
Gabe

I would set up your tasks and their associated rates on another worksheet
and then use a VLOOKUP function to call the amounts. If your data was on
Sheet2 A1:B10 (column A containing tasks, Column B their values, then in the
invoicing sheet you had the tsk to be entered in A2 and the quantity in B2
in C2 the formula would lokk thus:

=IF(A2="","",VLOOKUP(A2,Sheet2!$A$1:$B$10,2,FALSE)*B2)

This works if the quantity of hours is entered as 4.5. If you enter it
'properly' as 4:30 then the formula would be

=IF(A2="","",VLOOKUP(A2,Sheet2!$A$1:$B$10,2,FALSE)*(B2*24))

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 
Back
Top