Question about Microsoft Office Standard for PC

1 Answer

Excel i want to use 3/4 of a number rounded up and then the rounded up number as full number

Posted by on


1 Answer

  • Level 1:

    An expert who has achieved level 1.

  • Contributor
  • 1 Answer

Suppose ur number is at cell B2 with any value. lets say u want formula in A3. then A3 =*b2*3/4 to round back the A3 to full number the simpliest solution is to change cell formatint to NUMBER and set the decimal places to 0.

Posted on Sep 17, 2007


1 Suggested Answer

  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

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.
Good luck!

Posted on Jan 02, 2017


Add Your Answer

Uploading: 0%


Complete. Click "Add" to insert your video. Add



Related Questions:

1 Answer

How do I round a formula result in the same cell?

Did you ever try round? or press F1 for help on this?

Oct 30, 2014 | Microsoft Excel X for Mac

1 Answer

I need help with an excel formula. I am looking to get to a retail price, knowing the cost and the margin. For example, the cost is $10.00, margin is 25%, so my formula would be =10/75%. The total would be...


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


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

Mar 17, 2010 | Microsoft Excel 2003 (065-03992) for PC

3 Answers

How to round the fig. in Excel 2007 E.g. 12350*32.75% = 4044.625 I want it to be rounded to nearer rupee. If the decimal is lesser than 50, rounded fig. should be lower Rupee if the decimal is more than 50...

The function is called ROUND. It has 2 arguments, (1) the original number and (2) the number of decimal digits. Here is the Excel's help: ROUND(number,num_digits) The number you want to round. None. num_digits The number of digits to which you want to round number. If num_digits is greater than 0 (zero), then number is rounded to the specified number of decimal places. If num_digits is 0, then number is rounded to the nearest integer. If num_digits is less than 0, then number is rounded to the left of the decimal point.
So for your case use this in a cell "=ROUND(12350*32.75%, 0)" without quotes, where I assume one or both numbers will come from other cells. -Ken

Aug 29, 2009 | Microsoft Office Excel 2007

1 Answer

Excel 07 truncuating problem

You need to use the ROUND function.
E.g. type: =ROUND(A1,2)*A2

Assuming the 2.131576 is in cell A1 and 1000 is in A2.
The round function round the value to 2 decimals (in this case because I specified 2 as the second argument).

May 06, 2009 | Keystone Excel 2007 Essentials for PC...

1 Answer

Need a replacement bowl for my Kenwood Chef

I have an Excel that has the D shaped bowl but the base of it is round. Since the Excel does have a round base you can fit any existing bowl onto the Kenwood including their newer stainless steel bowl.

Mar 13, 2009 | Food Processors

1 Answer

Rounding off numbers

check the standard tool bar, increase decimal places/decrease decimal places tool will solve your problem.

Nov 04, 2008 | Computers & Internet

1 Answer

Random number generation.

you can use the Round function as below - it rounds out the decimal to 0 places, which gives you 5 digits with no commas


Jul 10, 2008 | Microsoft Excel for PC

3 Answers

Excel Formula

columns total in additin cells of rows equal are total

Oct 24, 2007 | Oracle 10g Database Standard (ODBSEONUPP0)

Not finding what you are looking for?
Microsoft Office Standard for PC Logo

54 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2971 Answers

Piyal Perera
Piyal Perera

Level 3 Expert

528 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18420 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides