if helf

  • Thread starter Thread starter willwood
  • Start date Start date
W

willwood

i have a list of customers in col A
and one customer attracts a rate o £10
all other customers attracy a rate of £15
in column c i have hours per job.
i want to multiply the hours by a rate applicaple per the customer?
 
=(10+(A2<>"the customer")*5)*C2

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Back
Top