See Mr Excel and excelisfun use two methods to convert from the numbers 10.1 and 10.2 to 10.333 and 10.667, and the reverse using two methods:
1. DOLLARDE and DOLLARFR functions
2. MOD and INT functions
3. Find and Replace elements in formulas
Coax Time Value From Text: MOD, LEFT, RIGHT, TEXT, MOD Functions DESCRIPTION See Mr Excel and excelisfun use the functions MOD, LEFT, RIGHT, TEXT, TIMEVALUE, and MOD to coax a time value from a time […]
DESCRIPTION Merge Product and Sub-Product Text; VBA or Wild INDEX Formula See Mr Excel and excelisfun use two methods to take a table of product names, each with 6 sub-products, and unwind the table to […]
DESCRIPTION Count Numbers that Contain Whole Number 4: COUNTIFS or SUMPRODUCT? Learn how to count numbers that contain the whole number 4: (00:11) Problem Introduction (01:05) COUNTIFS formula that uses Cell References, Comparative Operators and […]
Master Excel
Leave a Reply
You must be logged in to post a comment.