Excel has two functions that round numbers to either the next Even or Odd numbers – these functions are called … wait for it … Even() and Odd()! Both Odd() and Even() round positive numbers UP to the next odd/even number. Negative numbers are always rounded DOWN to the next lowest odd/even negative number. In […]
Excel’s Ceiling() and Floor() function rounds a number up or down to the nearest specified multiple. The most common use is to match prices to denominations of coins or notes. Ceiling() is similar to MRound() except that MRound() rounds to the nearest multiple, Ceiling() always rounds UP. The reverse is Floor() which always rounds down. […]
Here’s a complete list of the Outlook Function Key features from fast access to Help, jumping around your inbox, doc panes, spelling, grammar and key shortcuts. Let’s look in detail the functionality of the F-keys labelled F1 through F12 on your keyboard. F1 – Help, hide ribbon F2 – Calendar F3 – Search, change case […]
Each paragraph style can be seen alongside the text in Microsoft Word but it’s very much an afterthought that could be much improved. The Style Area Pane appears only in Draft and Outline view on the left-side. Turn on Style Area Pane Dig into Word for the Style Area Pane. File | Options | Advanced […]
How to insert the Zero Thirds (Baseball) ↉ fraction or symbol into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Zero Thirds ↉ symbol (officially called ‘Vulgar Fraction Zero Thirds’) is a rarely used Baseball scoring symbol. The best explanation we could find was a Japanese Wikipedia page, here’s […]
