14 Clients
You only need the IFs to pick up the exceptions - the other clients can
default to one rate, so something like this should do what you want:
=IF(L3="Hackney",25,IF(L3="Lewisham",30,26))
You might like to amend it to:
=IF(L3="",0,IF(L3="Hackney",25,IF(L3="Lewisham",30 ,26)))
so that you return zero if L3 is empty (more useful if you copy the
formula down).
Hope this helps.
Pete
Michell Major wrote:
Column P has a picklist of 14 clients. With exception of 2 they are charged a
standard rate of $26, the exceptions are $25 for hackney and $30 for lewis.
Howcan I write a better formula than the one below?
=IF(L3="Hackney",25,IF(L3="Lewisham",30,IF(L3="Pin nacle",26))) ... which
returns a FALSE because I cannot include all the arguments.
|