(877) 729-0812
We connect to your computer over the Internet to...
Answer
what are the disadvantages?
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
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.
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.
Yes
No
This Problem Also Relates To:
Sony Media Software Pictures Sound Effects Series - Volumes 1 to 5 Volume License (SSDS2000)
Sony Vegas Pro 8 for PC (SVDVD8006)
Sony ACID Music Studio 6.0 (ASAC6000)
Sony Acid Music Studio 7 for PC (MSAMS7000)
Encore Mavis Beacon Teaches Typing Deluxe 20 Full Version for PC
Encore The Print Shop 23 Deluxe Full Version for PC
Encore Carmen Sandiego Geography Learning System Full Version for PC, Mac
Popular Solutions for Business and Productivity
Questions and Unsolved Problems for Business and Productivity
Answer
Having trouble getting datbase formulas to work in MS Works 8.5
In particular I can't get a...
(More)
Answer
what is the product key for microsoft word 2007
Answer
I just recently got a digi 002 from a friend, I already had the Mbox 2, which works just fine,...
(More)
Answer
Error messages when trying to download Microsoft Office Home and Student 2007. There is a problem...
(More)
Ask our Experts
Browse popular Problems
More Common Problems
Most Common Problems for:
For Business and Productivity...:
Top Business and Pro... Experts
Experience:
I have owned a computer networking sales and service company.
Ask Me
Top Computer & Laptop Repair
