(513) 874-3306
We fix and repair laptop motherboard no video, no...
Answer
How do you fix an error 57E- when trying to update office 2003
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 Vegas Pro 8 for PC (SVDVD8006)
Sony Acid Music Studio 7 Full Version for PC (SAMS7000)
Apple AppleWorks 6.2.4 (M8761Z/A) for Mac
Apple iPlayMusic Beginner Guitar Lessons Full Version for Mac
Apple iWork 09 Family Pack Full Version for Mac
Belkin Easy-Transfer Cable for Windows XP and Windows Vista Business English DVD for PC
Encore 3D Home Architect Home & Landscape Deluxe Suite Version 9 for PC (705381139102)
Popular Solutions for Business and Productivity
Questions and Unsolved Problems for Business and Productivity
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 need a PC installation device for J-Max phones
Answer
i get accsess error register key accsess error when itry to load 2007 office
Sponsored Links
Ask our Experts
Browse popular Problems
More Common Problems
Most Common Problems for:
For Business and Productivity...:
Top Business and Pro... Experts
Experience:
Experienced a lot in computer troubleshooting.
Knowledgeable about cellular phones.
Ask Me
Top Computer & Laptop Repair
