Prev: Comments
Next: Working with dates
From: willwood on 4 Jul 2008 04:14
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?
From: Bob Phillips on 4 Jul 2008 04:34
=(10+(A2<>"the customer")*5)*C2

--
HTH

Bob

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

"willwood" <willwood(a)discussions.microsoft.com> wrote in message
news:904D3159-A28A-4529-8143-BA74D7BB5BDB(a)microsoft.com...
>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?


 | 
Pages: 1
Prev: Comments
Next: Working with dates