Question about Computers & Internet
I need to calculate a function which is contingent on another cell(3 different months) and produces a result.
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
A 6ya expert 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 repairmen in the US.
The service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
Posted on Jan 02, 2017
Tips for a great answer:
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
Oct 31, 2008 | Computers & Internet
Dec 12, 2010 | Texas Instruments TI-84 Plus Calculator
Sep 30, 2009 | Texas Instruments TI-89 Calculator
May 19, 2009 | Microsoft Excel for PC
May 06, 2009 | Keystone Excel 2007 Essentials for PC...
Mar 15, 2009 | Microsoft Office Excel 2003 for PC
Aug 25, 2008 | Microsoft Office Professional 2007:...
Oct 22, 2007 | Microsoft Excel 2003 (06503995)
Oct 13, 2007 | Microsoft Office Standard for PC
May 22, 2018 | The Computers & Internet
459 people viewed this question
Usually answered in minutes!