Question about Computers & Internet
a 6ya expert can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of.(from cars to computers, handyman, and even drones)
click here to download the app (for users in the US for now) and get all the help you need.
Posted on Jan 02, 2017
If I understand correctly the Round function will round up to the nearest tenth for .05 and above and round down for .04 and below. I am not entirely familiar with the use of the rounding function in a spreadsheet but it seems to me that if you can specify to round down ALL hundredths to the nearest tenth and then add .9 you will get the result you want. Or conversely, round up and minus .01. If this is possible you may want to apply the round function in one cell and then use another cell to add/subtract to get your x.x9 as I believe functions are not always applied in left to right order as read but are apllied in a specific hierarchy, in which case the subtraction/addition could be applied before the rounding and be lost. Using separate functions would overcome this.
Posted on Dec 08, 2008
SOURCE: Formula not working correctly
You need to change the =IF(AND to =IF(OR
Using AND is saying both conditions must be true. Using OR is saying either condition 1 or 2 need to be true
Posted on Apr 16, 2009
Tips for a great answer:
Jan 06, 2017 | The Computers & Internet
Jun 03, 2011 | Business Objects BusinessObjects...
Nov 15, 2010 | Microsoft Windows XP Professional
Apr 17, 2009 | Computers & Internet
Jan 01, 2008 | Microsoft Office Standard for PC
Nov 29, 2007 | Microsoft Excel for PC
23 people viewed this question
Usually answered in minutes!