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.
Other companies used the Standard Oil name to profit off of the company's reputation, but these organizations were never part of the company formerly controlled by Rockefeller. The Standard Oil Company of Ohio was the original company that Rockefeller established in 1862. In 1911, following the Supreme Court ruling, the company became known as Standard Oil of Ohio or SOHIO. The company, in effect, ceased to exist after being purchased by British Petroleum (BP) in 1970, although BP continued to sell gasoline under the SOHIO brand name until 1991.