Home | Business and Productivity Software | Multiple arguments in ...
Business and Productivity Software
Problem for Business and Productivity Software
Generic problem for all Business and Productivity Sof...

Multiple arguments in excel




By cindysibo1 on Nov 09, 2007

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

Solution #1

posted on Nov 15, 2007
Not Rated)

ccharacter

Rank: Master 
Rating: 68%, 11 votes
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:

=IF(A1="Jan",B1*0.25,IF(A1="Feb",B1*0.3,IF(A1="Mar",B1*0.4)))

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.
Was this helpful?
Yes
No

Popular Solutions for Business and Productivity


Questions and Unsolved Problems for Business and Productivity


Answer
How do you fix an error 57E- when trying to update office 2003

Answer
I updated the firm ware on my command 8 to make it sync to pt 7.4 on wxp serv pack 2, it now shows... (More)

Answer
i get accsess error register key accsess error when itry to load 2007 office


Didn't find what you were looking for?

Describe your problem:

Select a Category:





Sponsored Links



Ask our Experts

 

Solve Your Problem Now!
Chat Live with an Expert
Chat Now
Browse popular Problems
More Common Problems
Most Common Problems for:
For Business and Productivity...:

Top Business and Pro... Experts

Rank: Guru Guru  

Solutions: 418
Member Since: October 2009

Experience: Experienced a lot in computer troubleshooting. Knowledgeable about cellular phones.

Ask Me
Find more Business and Pro... Experts

Top Computer & Laptop Repair

(513) 874-3306
We fix and repair laptop motherboard no video, no...
LaptopOnCall Inc.

(877) 729-0812
We connect to your computer over the Internet to...
Remote Repair


       
Solve Your Problem Now!
Chat Live with an Expert
Chat Now

X
Continue
When the original poster rates a solution that was given to his own problem, that rating is locked!
X

Are you sure the solution content is Inappropriate?
   
Tech buddies can communicate directly to answer questions. Become a Tech Buddy and have direct access to your favorite expert for FREE!
Insert Link
Insert Image
Insert You-Tube clip
Insert List
Insert List
Spell Check

What is this?



Select