View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Anne Troy
 
Posts: n/a
Default Setting up a price list

Perhaps something like:
=if(isblank(a1),b1+c1+d1,a1*e1)
where a has hours, b is unit, c is exp, d is tax, and e is hourly rate.

************
Hope it helps!
Anne Troy
www.OfficeArticles.com
Check out the NEWsgroup stats!
Check out: www.ExcelUserConference.com

"G4" wrote in message
...
How do i Ask for the same argument from either one of two columns (IE Hour
or
Unit + exp+tax )