Issue with For Each Formula

Hi, hopefully someone can help me with this issue.

I have a sheet setup basically like this:

Column A ... Column G
Plant1 $10
Plant9 $14
Plant1 $12
Plant12 $15
Plant5 $20
...
Plant10 $25

I want to loop down A14:A24 and check if any of the cells contain "Plant 1" through "Plant 7". If they contain any of those plants I then want it to
loop through G14:G24 and multiply the corresponding value in that row by 1.1

I have the following code so far:

Please Login or Register  to view this content.

It's working so far that it loops through both columns but instead of multiplying by 1.1 it seems to be multiplying by 2.85?

Any idea what could be causing this? I'm always open to recommendations to simplify the code.

Thanks.

And, you only have to loop thru range A14:A24 to check the correct plant name, and, if found, do the math in G14:G24.

This was my problem right there.

I removed the nested "For Each" so it only loops through column A then applies the math in column G and now everything is working correctly.

Thank you for the help!