In that case, you could use this formula in column E to calculate a new price: =IF(OR(B6=red,B6=green),C6*1.15,C6) The test is the same as before, the action to take if TRUE is new. If the result is TRUE, we multiply the original price by 1.15 (to increase by 15%).
Standard Oil Corporation. joint stock company founded by John D. Rockefeller in 1870 in Ohio. As the company grew it was established in four other states (New Jersey, New York, California, and Indiana) because of stric laws against interstate corporations. For this purpose the Standard Oil Trust was formed in 1883.
Standard Oil Co. purchases a three-quarters interest in Vacuum Oil Company for $200,000. As a lubricants pioneer, Vacuum Oil introduces a number of popular products, including the revolutionary Gargoyle 600-W Steam Cylinder Oil. Standard Oil lubricates Thomas Edison's first central generating system. Also in this year, Standard Oil Trust forms to include the Standard Oil Company of New Jersey (Jersey Standard) and the Standard Oil Company of New York (Socony). The Standard Oil Trust moves its headquarters to 26 Broadway, New York City. The nine-story office building becomes a landmark.