Home > Default > I have a calculation in a5 and need the answer rounding up to the next whole number

I have a calculation in a5 and need the answer rounding up to the next whole number

November 30Hits:0
I have a calculation in cell a5 and need the answer rounding up to the next whole number

Hi,
I am using numbers
A1 x A2 = A3       A4 is A3 divided by 2.88.  Indeed to round up the answer in A4 to the next whole number
Eg 4.5 x 3.7 = 16.6 sq meters as an area , divided by 2.88 ( area of 1 board) = 5.78 boards so I need to buy 6 and quote for 6
Cheers

Tags:

Related Articles

• I have a calculation in a5 and need the answer rounding up to the next whole numberNovember 30

I have a calculation in cell a5 and need the answer rounding up to the next whole numberHi, I am using numbers A1 x A2 = A3       A4 is A3 divided by 2.88.  Indeed to round up the answer in A4 to the next whole number Eg 4.5 x 3.7 = 16.6 sq meters as

• Calculating intersection of circles giving NaN first 'round'.October 11

See attachment. When I give the correct parameters as input, the output is always NaN. However, when I run the VI again, the correct x,y coordinates are returned. Obviously this is not correct behaviour I want in my VI. What did I do wrong here? Than

• Java Calculator, Minus & multiplication button gets wrong answer?November 30

import java.awt.event.*; import java.applet.Applet; import javax.swing.*; import java.awt.*; public class calc extends JApplet implements ActionListener      JTextField input = new JTextField("");      JButton numbers[] = new JButton;      J

• Cannot trust calculator 50g to give the right answerNovember 30

50G gives the wrong answers: Pick equation from Library:  APPS; Equation Library, F1, F1, Plane Geometry, Rectangle, F1, enter number for b and h, solve for A. ( Lets go with b=6, h=2, and A will become 12). So far so good. Now R-Shift NUM.SLV; pick

• Income tax calculation errorOctober 11

Dear All for an Employee , his total taxable income is Rs 2,65,395 pe annum so  per month it would be Rs 22116. But it is showing income tax for april month as Rs 44,210. His PAN is also being maintained. Kindly guide me in resolving this issue. Rega

• Need help with date and time calculations pleaseOctober 11

Hello there.. Im stuck, and im hoping someone can help.. Working on a list to manage and track PTO.  User completes PTO request form, Fields Name Start Date (with time) End Date (with time) Total Number of Days/hours requested: (calculation) Full Day

• Use Period member in CalculationOctober 11

I have a Hyperion Financial Report which has members in the Period dimension as Jan, Feb, March, etc. In my report, I need to make a calculation based on this month, for eg., If Month = May (I need the number of the month which is 5). For example, le

• Item Transaction History Report - Calculation for creating 'Running Total'October 11

Hello Using Oracle Discoverer, we have written a report that pulls back all Inventory Transactions (by item number). This report lists both transactions IN (e.g. receipts into the store) and OUT (e.g. issues out from the store). Our customer would li

• Interest Calculation for special GL itemsOctober 11

Hi Experts, We have posted some special GL indicator documents for the vendors, but in the interest calculation, that is not coming up. However the system is picking up all the others debit and credit items for that vendor. So what could be going wro

• Interest on arrears calculationOctober 11

Hi all, I would like to set the interest calculation for customer in the following way, can this be done? please advice.  If the customer line item is due during the month and the payment is received after the due date, when i run the interest calcul