On Wed, 18 Oct 2006 03:20:02 -0700, 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="Pi nnacle",26))) ... which
returns a FALSE because I cannot include all the arguments.

Build a table with names in one column and rates in adjacent column. Then use
VLOOKUP (see HELP for details).


--ron