|
Excel IF Statement Let's say you have a spreadsheet full of products and you want ones that sell for less than $100 to be automatically increased by 10%. What you need is an IF statement that allows you to apply the 10% increase based on the criteria. Try it out in the interactive spreadsheet below. Change any of the numbers in the "Price" column to an amount less than or greater than $100 and see what happens in the "Adjusted Price" column. This interactive worksheet works in Internet Explorer only. Those using some other browser click here to see a screenshot of the spreadsheet if you do not see the Interactive version displayed. (You won't see it if you don't have Excel installed on your computer either. Or, if you are using a version of Excel other than 2002, the clsid value in the registry is different and you can download this registry fix to cure that. Just extract it to your desktop and double click it, then you can delete it.)
Double click inside any cell in column C to see the formula. It looks like this: =IF(B3<100,(B3+(B3*0.1)),B3) This IF statement tells Excel "If the value in B3 is less than 100, give me what's in B3 plus 10% of B3. Otherwise, just give me what's in B3, as is." This is a simple IF statement. Try changing the conditions in the IF formula and see the results you get. MORE DETAILED TUTORIALS ON IF STATEMENTS HERE.
|
.
