Excel Forum



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.