Excel Forum
Similar Content
Countdown Timer in Excel
Tutorial: How to create a countdown timer in Excel. This allows you to display a timer in whatever c...
Change Formulas to Absolute or Relative References
Macro: This macro will change the formulas in cells to absolute or relative. It allows you to cha...
Group Data Together for Increased Readability in Excel
Tutorial: How to group data together or collapse it in order to focus only on the important data in...



Mr Excel & excelisfun Trick 71: ROUND to 4 or 2 Formula or Conditional Formatting?


See Mr Excel and excelisfun round numbers to 2 if the column says "DOLLAR" and 4 if the column says "CRUDE" using the functions ROUND, IF and VLOOKUP and see how to do it with amazing Conditional Formatting Logical Formula and the Number tab!





Got a Question? Ask it Here in the Forum.