0
A formula that makes calculations based on stated conditions in excel?
Wiki User
∙ 14y ago
An IF formula.
Wiki User
∙ 14y ago
Add your answer:
Earn +20 pts
How could you find the deflection in a fight of stairs using hand calculations?
You can find the deflection in a flight of stairs using hand calculations by first measuring all angles and lengths. These can then be entered into a formula which calculates deflection based on these variables.
Which Excel function is used to perform conditional calculation?
You can use the IF function to do calcutions based on conditions. You can also use SUMIF, COUNTIF and AVERAGEIF to do calculations too.
What are the benefits of using formulas in excel especially for a lot of data?
The basic idea of formulae is that when the numbers on which a formula is based change, the formula is automagically recalculated. You can have a long series of calculations, each of which depends on earlier results.
What type of Federal grant to the states is awarded based upon state and local conditions such as poverty or unemployment rate?
Formula Grant
Who is known for publishing an almanac based on my astronomical calculations?
me
What is the molecular formula based upon?
The formula is based on the chemical composition of the molecule.
Excel tables are based on what concepts?
They are based on the accountant's paper-based spreadsheet, which consists of rows and columns into which values can be put and calculations can be done. The electronic spreadsheet enables the calculations to be done automatically and provides a whole host of other features that a paper-based spreadsheet can never achieve.
What statement accurately describes how costs and benefits are calculated?
Calculations of cost and benefit are based on personal preferences.
What describe how costs and benefits are calculated?
Calculations of cost and benefit are based on personal preferences.
How are mass calculations used?
Mass percentage calculations determine the percentage of an element based on mass in a compound. This can then be used to determine the percentage in a compound of each individual element.
How do you know how much medicine to give a person?
This is a combination of things, based on recommended guidelines published by a prescribing body (e.g. the British National Formulary in the UK) that gives you precise guidelines, or based on formula used to calculate the desired effect based on a patient's age or other conditions.
When are calculations rounded-off based on least precision?
They should be. Certainly before presenting results.
