New to Excel? Looking for a tip? How about a tip so mindblowingly useful as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 334th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the IF function. This video starts with IF function basics and then shows 12 different examples of how the IF function can be used in formulas. Also see how to use AND, OR, SUM, AVERAGE, STDEVP and VLOOKUP functions.
 Hot
 Latest

How To: Find a PValue with Excel

How To: Generate random numbers (with decimals) in Excel

How To: Compare two lists in Excel with match, join and filter

How To: Cross tabulate categorical data in Microsoft Excel

How To: Measure the spread of a data set with Excel's AVEDEV

How To: Update inventory records by formula in Microsoft Excel

How To: Create an Excel inventory template with running totals

How To: Instantly Change Blocks of 'CAPITALIZED TEXT' in Microsoft Word to 'Lowercase Letters'

How To: Calculate monthly retirement income in Microsoft Excel

How To: Calculate proportions and percentages in Excel

How To: Create dynamic sub tables in Microsoft Excel

How To: Insert, format, resize & crop pictures in MS Word

How To: Graph the probability density function in an Excel file

How To: Completely hide the Ribbon menu in Excel

How To: Link two (multiple) workbooks & cells in Excel

How To: Create a relative frequency distribution in MS Excel

How To: Create a scatter diagram for 2 variables in Excel

How To: Work with bank checks in Microsoft Excel

How To: Create a stem & leaf chart with Excel's REPT & COUNTIF

How To: Calculate expected returns for a portfolio in Microsoft Excel

How To: Find a PValue with Excel

How To: Generate random numbers (with decimals) in Excel

How To: Compare two lists in Excel with match, join and filter

How To: Cross tabulate categorical data in Microsoft Excel

How To: Measure the spread of a data set with Excel's AVEDEV

How To: Update inventory records by formula in Microsoft Excel

How To: Create an Excel inventory template with running totals

How To: Instantly Change Blocks of 'CAPITALIZED TEXT' in Microsoft Word to 'Lowercase Letters'

How To: Calculate monthly retirement income in Microsoft Excel

How To: Calculate proportions and percentages in Excel

How To: Create dynamic sub tables in Microsoft Excel

How To: Insert, format, resize & crop pictures in MS Word

How To: Graph the probability density function in an Excel file

How To: Completely hide the Ribbon menu in Excel

How To: Link two (multiple) workbooks & cells in Excel

How To: Create a relative frequency distribution in MS Excel

How To: Create a scatter diagram for 2 variables in Excel

How To: Work with bank checks in Microsoft Excel

How To: Create a stem & leaf chart with Excel's REPT & COUNTIF

How To: Calculate expected returns for a portfolio in Microsoft Excel
1 Comment
In excel07 I need to write formula if excel
If (cell A1)is less than 100 then multiply by2.47,If it is greater than 100 but less than 300 then multiply by 4.37, If it is greater than 300 but less than 500 then multiply by 6.25, If it is greater than 500 but less than 1000 then multiply by 7.25, If it is greater than 1000 then multiply by 7.50,
The above rate is for one month i.e.30 days
Now Question:8000 value calculated in 7 months.
Share Your Thoughts