=IF(ISNUMBER(SEARCH("High",A2)),B2*.85,IF(ISNUMBER (SEARCH("Medium",A2)),B2*.60,IF(ISNUMBER(SEARCH("L ow",A2)),B2*.45,"answer
unspecified")))
--
David Biddulph


"James" wrote in message
...
I've exported data from a database and then performed a subtotal/count. I
need to multiply the count of the different criteria by three different
values.
If the Cell contains the word "High" I need to multiply the count by .85
if
"Low" by .45 and if "Medium" by .60

Area one Non Accommodation High Large 14
Area sixteen Non Accommodation High Small 7
Area three Accommodation Medium Small 6
Area one Accommodation Low Small 2
Area Five Non Accommodation Low Large 10
Area six Non Accommodation Medium Large 9

Cell A2 contains Area name and type and B2 contains the count.

Any help gratefully received.