excel in courses - What are the basics for formulas

click the fx to the left of the formula bar near the top of your workbook for a list of available formulae and play around!!

most commonly used formula I reckon is the if statement.


in cell B1, type the following:

=if(A1>10,"big number","small number")

this will return "big number" or "small number" based on the value in cell A1. if it's a number less than or equal to 10, it will return "small number" in cell B1, if it's a number larger than 10, it will return "big number"