Question about Microsoft Excel for PC

Excel formulas Premium Age of Client (% of car value) Under 25 10% Over 25 5%

Posted by on

• Level 1:

An expert who has achieved level 1.

Hot-Shot:

An expert who has answered 20 questions.

Corporal:

An expert that has over 10 points.

Mayor:

An expert whose answer got voted for 2 times.

• Contributor

To totally exclude age 25, =if(age of client <25,10%,if(age of client>25,5%,0))

to include 25 under 10% premium, =if(age of client <=25,10%,5%)

to include 25 under 5% premium, =if(age of client <25,10%,5%)

Posted on Nov 17, 2008

• Level 1:

An expert who has achieved level 1.

Hot-Shot:

An expert who has answered 20 questions.

Corporal:

An expert that has over 10 points.

Mayor:

An expert whose answer got voted for 2 times.

• Contributor

=IF(A1 < 25,10/100 * B1, 5/100 * B1)

A1 is the Age of client
B1 is the car value

Posted on Oct 27, 2008

Hi,
a 6ya Technician 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 repair professionals here in the US.
Goodluck!

Posted on Jan 02, 2017

×

my-video-file.mp4

×

Related Questions:

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.

1. All formulas begin with an equals sign (=).
2. Some formulas use operands such as +,-, *,/ for addition, subtraction, multiplication or division.
For example, the formula =A1+A2+A3 would add the contents of cells A1, A2 and A3.
3. Other formulas refer to different functions such as SUM, AVERAGE and others.
For example, the formula =SUM(A1:A3) would add the contents for the range A1 through A3.
4. Formulas can be combined with operands.
For example, the formula =10*SUM(A1:A3) would add the contents cells A1 through A3 and multiply them by 10.
5. Functions can be nested within each other.
For example, the formula =SQRT(10*SUM(A1:A3)) would take the square root of ten times the sum of cells A1 through A3. When functions are nested, it is important that the number of left parentheses match the number of right parentheses.

Aug 19, 2011 | Microsoft EXCEL 2004 for Mac

Problem was found in Micorsoft excel 2003. When I copy the formula from one (original) cell to another (new) cell, the formula in the new cell has updated but the value show on the new cell was the...

Once you have copy the cell from where the formula cam from, on the destination cell,
go to
1. Edit
2. Paste Special
3. Formula.
4. Press Enter

This should resolve your problem. Regards.

Aug 11, 2010 | Microsoft Office Excel 2003 for PC

Copy data that contains formula and paste it to a new sheet minus the formula: is this possible?

Sure is - depending on your version of Excel.

1) right click on the cell with the formula
2) go to where you want to paste the value - minue the formula
3) right click and select paste special
4) click values (as seen in image below)

and that's it done.

Oct 09, 2009 | Microsoft Excel for PC

When I create a formula in a cell, hit enter, I get #VALUE. How do I get the actual result to appear, instead of #VALUE?

#VALUE? is an error indication meaning that Excel can't process the formula. It is most likely the result of a bad cell reference in your formula, for example, you may be trying to perform mathematical operations on a cell that contains non-numeric text data.

Jul 21, 2009 | Microsoft Office Excel 2007

MS Excel-Values in the formula in place of cell reference

Copy the cell(s) and then right click on the cell(s). Choose Paste Special and then choose Value. That will convert it.

Jun 22, 2009 | Microsoft Excel for PC

Countifs

The formula in both versions is the same:

=countif(range,value)

i.e. The below formula will increase its count by one if any of the 18 cells it's checking are equal to 1.
=countif(A1:B9,1)

Jan 21, 2009 | Microsoft Office Excel 2003 for PC

Circular reference working how to open excel file

Clicking cancel will invalidate the formulae, circular references refer to the dependant and precedent cells using each other.

Track/ Audit depending on your Excel version to show which formulae is incorrect - or options view, tick show formaulae and remove them.

Nov 20, 2008 | Microsoft Excel for PC

Excel will not displaying the results of a trend array formula

Hi Griffnz,

Your "known Y's" or 'values' are in Column B. This is the first array in the Trend formula.

Your "known X's" or 'months' are in Column A. This is the second array in the trend formula.

The trend formula is supposed to give you a projection of what the rest of the values in Column B will be over the next few months (usually continuing cells in Column A). The cells you want these values to show up in represent the third array in the formula.

Thus, your formula should look more like: '=trend(B3:B14,A3:A14,A15:A18)'

However, your formula is leaving out The values in B and adding values from C - -- but there ARE no values in C. Apparently, C is where you want the values to appear. In that case, the C array would be the third array in your formula. This would look more like '=trend(B3:B14,A3:A14,C3:C14)

If this doesn't make sense, let me know.

Sep 30, 2008 | Microsoft Excel for PC

Excel formulas

type in "=" and then go to the cell in the 2nd sheet and click on the cell that contains the value you want carried to sheet 1. Then drag copy the forumula in sheet 1 to all the cells you want it to relate to. Now, if you place a value in e.g. A1 of sheet 2, then that same value will appear in A1 of sheet 1.
Good luck.

Sep 13, 2008 | Microsoft Computers & Internet

Related Topics:

119 people viewed this question

Level 3 Expert

Level 3 Expert