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.

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


"James" <(E-Mail Removed)> wrote in message
news:43659048-DAB5-4F50-BEA7-(E-Mail Removed)...
> 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.
>
>

=NOT(ISERROR(FIND("High",A1,1)))*.85+NOT(ISERROR(FIND("Medium",A1,1)))
*.6+NOT(ISERROR(FIND("Low",A1,1)))*.45


On 20 Lis, 13:37, James <Ja...@discussions.microsoft.com> wrote:
> 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.

Try
=B1*IF(ISNUMBER(SEARCH("low",A1)),0.45,
IF(ISNUMBER(SEARCH("medium",A1)),0.6,
IF(ISNUMBER(SEARCH("high",A1)),0.85,1)))

If this post helps click Yes
---------------
Jacob Skaria


"James" wrote:

> 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.
>
>

Thank you all for your replies this is exactly what i was looking for.

James :-)

"James" wrote:

> 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.
>
>