Question about Microsoft Excel for PC
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
Here is your formula
=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
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.
click here to Talk to a Technician (only for users in the US for now) and get all the help you need.
Posted on Jan 02, 2017
Tips for a great answer:
Apr 10, 2013 | Microsoft Excel for PC
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.
Aug 19, 2011 | Microsoft EXCEL 2004 for Mac
Aug 11, 2010 | Microsoft Office Excel 2003 for PC
Oct 09, 2009 | Microsoft Excel for PC
Jul 21, 2009 | Microsoft Office Excel 2007
Jun 22, 2009 | Microsoft Excel for PC
Nov 20, 2008 | Microsoft Excel for PC
Sep 30, 2008 | Microsoft Excel for PC
Sep 13, 2008 | Microsoft Computers & Internet
Jan 28, 2016 | Microsoft Excel for PC
Dec 12, 2013 | Microsoft Excel for PC
Jul 23, 2013 | Microsoft Excel for PC
119 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: