Question about Business & Productivity Software

1 Answer

Multiple arguments in excel

I need to calculate a function which is contingent on another cell(3 different months) and produces a result.

Posted by on

1 Answer

  • Level 1:

    An expert who has achieved level 1.


    An expert that hasĀ over 10 points.

    Problem Solver:

    An expert who has answered 5 questions.

  • Contributor
  • 16 Answers
Re: multiple arguments in excel

Okay, here's a possible solution--based on my interpretation of your problem.

Suppose you have some value in cell B1, and the month (either Jan, Feb, or Mar) is stored in cell A1. The formula in C1, which performs calculations based on which month appears in A1, is as follows:


In this example, the value in B1 is multiplied by .25 if the month is Jan, by .3 if it's Feb, and .4 if it's Mar.

Posted on Nov 15, 2007

Add Your Answer

0 characters

Uploading: 0%


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


3 Points

Related Questions:

1 Answer

What is the "&" symbol for in excel 2010?

The "&" symbol is commonly known as "ampersand" and it is a calculation operator. Ampersand can be used in Excel 2010 to join text items from different cells. It functions much similar as "CONCATENATE" function. The output value you will get by using ampersand function will be the same as the one you will get by using CONCATENATE function. For example, =A1 & B1 returns the same value as=CONCATENATE(A1, B1)

To know more about the CONCATENATE/ ampersand function, you can refer to the following webpages:

(Important: Below mentioned link is of a third-party website. We recommend you to update your security software thoroughly before clicking on the link.)

(Important: Below mentioned link applies to Excel 2007. Still, you can refer it to understand more about ampersand function.)

Jul 30, 2014 | Microsoft Excel 2010

2 Answers

What are the formulas in grading the grades uisng microsoft excel

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

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

How to calculate the difference of two dates by year, month and day using the formula in excel?

To calculate the difference in Years use =Year(c,r)-Year(c,r)
To calculate the difference in Months use =Month(c,r)-Month(c,r)
To calculate the difference in Months use =(c,r)-(c,r)

c= column, r= row

You will need to format the source cells as dates

Mar 15, 2009 | Microsoft Office Excel 2003 for PC

1 Answer

Calculation of end date in format dd/mm/yy

Assuming you put the start date in cell A1, put this formula:


in the cell where the result wanted to be appeared.

P.S.: If this information was helpful, please rate this solution.

Mar 12, 2009 | Microsoft Office Excel 2003 for PC

2 Answers

Excel farmulas

Add another colum, say D with result of B*C

Do a list of the different cat, and use sumif
For cat 0101 (in cell F1)
formula to put in G1
=sumif($A$1:$A$7000;F1;$D$1:$D$7000) where F1 contain 0101

expand the formula for other cat. (G2, G3, etc)

You can use a assistant to extract the distinct cat from A1:A7000, sorting them and copy the result in F (Menu Data-> Filter -> elaborate filter)

Feb 16, 2009 | Microsoft Excel for PC

2 Answers

Formula for calculating the days beween months

for example, cell A1 has date (01-01-2008) and cell A2 has current date (08-24-2008) and cell A3 shows total days, is that you want to know? if yes, apply formula as under...

cell A3......(properties set as General to show digits)................ =SUM(A2-A1)

Aug 25, 2008 | Microsoft Office Professional 2007:...

3 Answers

Excel argument

If I understand correctly, you want to figure the normal wages at 40 hours and less. If there is more then 40 hours, calculate the normal 40 hours, then calculate the hours overtime (time and a half) and add them to get a total.


B5 columns are filled with this:

NOTE: The $ sign doesn't refer to money, it refers to an absolute reference so when copying a formula, the cell references with a $ sign are fixed and don't adjust according to the relative position to where it's being pasted.

Please rate as FixYa! or ask please clarify. ThankYa!

Oct 22, 2007 | Microsoft Excel 2003 (06503995)

1 Answer

Emi using excel

The function in Excel for calculating EMI is not EMI but PMT. It requires minimum three arguments. They are 1. Rate of interest (Rate), 2. Number of periods (Nper) and 3. Value of loan or present value (Pv) in that order, that is, PMT (Rate, Nper, Pv) If you want to find EMI for 1 lakh at 10% annual interest for 10 years you enter the following in one of the cells: = pmt(10%/12, 10*12, 100000)

Borrowed from

Oct 13, 2007 | Microsoft Office Standard for PC

Not finding what you are looking for?
Business & Productivity Software Logo

Related Topics:

458 people viewed this question

Ask a Question

Usually answered in minutes!

Top Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers


Level 3 Expert

18258 Answers

Sudeep Chatterjee
Sudeep Chatterjee

Level 3 Expert

3267 Answers

Are you a Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides