help with if functions excel?

Question

are there any sites for practicing simple if functions

Answer 1

IF functions are really simple and quite logical. You use an IF function when you want to return a certain value or text if another cell contains the criteria you enter into the function but you also have to say what will happen if the criteria is met. Therefore an IF function has three parameters, the criteria you are looking for, what happens if it meets the criteria and what happens if it does not. Each parameter is separated by a comma. Therefore if you have in column A a list of values starting A2 ranging from 30 to 100, and want to put an IF function in column B to say that if the value in A2(which you will then autofill down) is less than 50 you will add 10% onto the value, but if it doesnt meet that criteria, i.e. it is 50 or more, you will add 15%. The function would be (in cell B2) =if(A2<50,A2*10%+A2,A2*15%+A2) and then autofill that down. If you want to put text in rather than a value, remember that text in a formula or function must be shown in quotes ("). Hope this helps you, but principally, 3 parameters, the criteria, what happens if it meets the criteria and what happens if it doesn't. It would only be in a COUNTIF, or SUMIF function that you would have two parameters only as it would not be concerned with the cell if it didnt meet the criteria.

Answer 2

1

Answer 3

open a new excel spreadsheet and press F1

simply type - if - in the search field

3 good "if" examples and the alternative "lookup"



if you're "into" finding out what other functions do -

open a new excel spreadsheet and click on the fx= icon on the toolbar (if the icon is not on your toolbar go to the menu item "insert" and choose "function")



when the window opens select category "All" , click on the first item in the "select function" list and just start arrowing down the list. an explanation of the function appears under the list box.



you would be amazed at what Excel can do. (my favourites are "concatinate" "left" and "right" - it's phenominal what you can do with a list using these 3 functions)



the other thing i found for picking data out of a very long list is the "data" / "filter" - hint: the column headers cannot be separated from the data by a blank row and the data list must not have any totally blank rows or columns separating it. there is a way around this by hiliting the entire range of data you want to work with and then choose the "data / filter" action. once you set the criteria you want and the data is displayed, you can hilite it , copy and paste it on another page in the file and work with that data alone.



have fun

Answer 4

IF function is really simple and quite logical.. We use an IF function when you want to return a certain value or text if another cell contains the criteria you enter into the function but you also have to say what will happen if the criteria is met. Therefore an IF function has three parameters, the criteria you are looking for, what happens if it meets the criteria and what happens if it does not. Each parameter is separated by a comma.

Answer 5

Not that I ever found... but here's a nice complicated one to help you see the power of the IF statement:



=IF(ISBLANK(A1), 0, IF(A1-B1<=0, 0, IF((D1-C1>365), 0.15 * (A1-B1), 0.25 * (A1-B1))))



Put this into Cell E1 and put dollar amounts into Cells A1, B1, and put Dates into Cells C1, D1.



Here's what it does: it is a triple nested "IF" that checks first to be sure cell A1 is not empty ("ISBLANK(A1)")... if it is empty then it only puts a zero into cell E1, otherwise it puts the value of what is on the rest of the line...



Next... the rest of the line determines if you sold a stock for a gain or a loss (yeah, those dollars amount are going to be stock prices, or actually total amount of money paid and total amount sold - cool, huh?)



The "IF(A1-B1<=0" checks if you sold the stock for a gain or a loss - there is no tax on losses, only if you made money. The second zero after that (A1-B1<=0, 0,) means if there is a loss you will put Zero - change the values of A1 and B1 to be higher or lower than each other and see E1 change from Zero to a value and back to Zero.... still with me?



Good... now: the final part "IF((D1-C1>365)" checks whether you sold the stock as a short term sale or a long term sale (that's greater than 365 days to be long term and pay 15% - or pay your normal tax rate of 25% - you might need to change it to your own tax rate of course).



To see the tax rate part in action change the two Date fields (C1 and D1) to different values that are less than one year or more than one year apart...



Does that help??

...

Answer 6

A common misconception is that you will have to be a financial and business expert in order to successfully trade binary options. However, this is not true at all. Learn here https://tr.im/ObEXR



Perhaps it’s true when it comes to traditional stocks trading but definitely not true in the case of binaries. You don’t have to be an expert to predict the movement of certain assets.

Answer 7

Start by pressing F1



Excel Help file gives examples.

Answer 8

the answer is to apply countif and offset worksheet purposes alongside with offset nested interior countif. anticipate you have your 12 mth table on sheet2, aside from the column titles it is the month quantity the information block is A2:L21. The cellular to coach consequence, you place formulation =COUNTIF( OFFSET( Sheet2!A2:A21, 0,A1 ,20,one million),one million) interior the offset functionality: Sheet2!A2:A21 is the 1st mth information 0 is the offset of row, beside the point thus A1 is the offset of column, enter integer variety from 0 to 11(1st mth to twelfth mth) in cellular A1, or straight away replace A1 with integer of that variety. whilst enter 0(the two interior the formulation or in cellular A1), it capacity utilising A2:A21(1st mth) itself, if 11 is entered, it capacity pass suitable 11 column from A2:A21 it is the twelfth mth. 20 is the kind of rows you like the formulation return, one million is the kind of column you like the formulation return. desire this facilitates.

Answer 9

here's a link to some great excel tutorials... I'm sure you can find what you're looking for there...



http://office.microsoft.com/en-us/training/CR061831141033.aspx