View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default How to set up a cost estimate spreadsheet?

In case you don't want zeros to appear in column D until you enter some
hours in column C, you could amend the formula in D2 to:

=IF(C2=0,"",B2*C2)

and copy this down.

Hope this helps.

Pete

damorrison wrote:
If Name was A2
$$ amount was in B2
Hours were in C2

Type this in D2 =B2*C2 then enter

It appears you could use a crash course in Excel basics Here's a site
to get you started

http://usd.edu/trio/tut/excel/index.html