=INT(A1)+0.95
With A1 being the reference to the cell you wish to round up
What that does is first round down the number to a whole one then adds 0.95 to the figure
Hope this gives you the information you need
Bob
Moderator
It would be very decent of you to consider the quality of our expert’s answers and judge them accordingly as you pass through FixYa.
Thank you
Did that do the trick ?
online 4u adipex advicer baccarrat blackjack bllogspot booker byob car-rental-e-site car-rentals-e-site carisoprodol casino casinos chatroom cialis coolcoolhu coolhu credit-card-debt credit-report-4u cwas cyclen cyclobenzaprine dating-e-site day-trading debt-consolidation debt-consolidation-consultant discreetordering duty-free dutyfree equityloans fioricet flowers-leading-site freenet-shopping freenet gambling- hair-loss health-insurancedeals-4u homeequityloans homefinance holdem holdempoker holdemsoftware holdemtexasturbowilson hotel-dealse-site hotele-site hotelse-site ****** insurance-quotesdeals-4u insurancedeals-4u jrcreations levitra macinstruct mortgage-4-u mortgagequotes online-gambling onlinegambling-4u ottawavalleyag ownsthis palm-texas-holdem-game paxil ***** pharmacy phentermine poker-chip poze ***** rental-car-e-site ringtones roulette shemale shoes slot-machine texas-holdem thorcarlson top-site top-e-site tramadol trim-spa ultram valeofglamorganconservatives viagra vioxx xanax zolus
×
Formulas are used to specify calculations based on values in designated cells. Excel supports basic calculations as well as statistical, trigonometric and other specialized functions.
Formulas used in Excel must follow a certain syntax.
Calculate the amount if you know the total and percentage
For example, if you purchase a computer for $800 and there is an 8.9% sales
tax, how much do you have to pay for the sales tax? In this example, you want to
find 8.9% of 800.
Example
The example may be easier to understand if you copy it to a blank
worksheet.
166 views
Usually answered in minutes!
×