Im sure this is simple for you but it has been driving me crazy. I need the value in a1 to equal b1 then when i put a value in a2 i want the sum in b2 and so forth.

4 4

4 8

0 8

4 12

Then i need a countdown. I start with a value 100 in d1. Then the value decreases by the value in e1.

Example

d1 e1

100 0

95 5

can you help with these functions. Thank you

Ad

Hello.

For cell B1 you can use this (without the quotes) "=A1"

Then for cell A2 and down you don't need a formula, but for B2 you can use this formula. "=(B1+A2)" Then click on that cell and drag the mouse down for as many cells as you want this formula to include and press Control and F keys to fill the formula down the column.

For your second formula, you would type 100 into D1 and in D2 you would use the formula "=D1-E1" (again, no quotes).

Feel free to let me know if you need any more clarification or if I missed something!

Posted on Jun 11, 2008

Ad

Hi,

a 6ya Technician 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 repair professionals here in the US.

click here to Talk to a Technician (only for users in the US for now) and get all the help you need.

Goodluck!

Posted on Jan 02, 2017

Ad

Assuming that the Original Value is in cell A1, and the New Value is in cell B1, then the formula for % Change pin Value is =(B1/A1)-1.Format the value in % style and you're done.Rgds,Scott

Sep 30, 2011 | Microsoft Excel for PC

use if statement

=IF(AND(OR(A1="clark",A1="skamania",A1="clickitat"),B1="WA"),1,0)

where A1=T2 and B1=U2

=IF(AND(OR(A1="clark",A1="skamania",A1="clickitat"),B1="WA"),1,0)

where A1=T2 and B1=U2

Jul 16, 2009 | Microsoft Office Excel 2007

Use this formula in B1: =CHOOSE(A1,"GOOD","FAIR","BAD")

With this you must have 1, 2, or 3 in A1 or you will get a #VALUE error in B1.

With this you must have 1, 2, or 3 in A1 or you will get a #VALUE error in B1.

May 20, 2009 | Microsoft EXCEL 2004 for Mac

In A1, put a random value of d as 0.1. Then in B1, put your equation 5*d^4 - 10.29*d^(-1.333), wherein refer d as A1. Then use goal seek function on Tools Menu. First "Set cell" as B1, "To value" as 0.124 and "By Changing Cell" as A1. Excel will do the Trial & Error and will give you the answer in Cell A1.

Nilesh

Nilesh

Mar 31, 2009 | Microsoft EXCEL 2004 for Mac

You need a cell to put these numbers first. Lets say A1 is your reference cell where the numbers are going to be input. B1 is the cell that you are going to see the calculation. Type the following formula in B1

=IF(A1<4,4*60,A1*60)

after doing this you can put any number in A1 and it will give you the calculation in B1 as the way you wanted.

=IF(A1<4,4*60,A1*60)

after doing this you can put any number in A1 and it will give you the calculation in B1 as the way you wanted.

Feb 24, 2009 | Microsoft Excel for PC

Any formula in Excel starts with the equals sign ("="). This is how Excel distinguishes between formulas and literal values. Knowing this, you can create lots of formulas using the usual operators of +, -, * and / for addition, subtraction, multiplication and division, respectively. Please see the examples below.

Add 1 + 1: =1+1

Add the contents of cell A1 to the contents of cell B1: =A1+B1

Subtract 2 - 1: =2-1

Add the contents of cell A1 from the contents of cell B1: =B1-A1

Multiply 1 times 2: =1*2

Multiply the contents of cell A1 times the contents of cell B1: =A1*B1

I hope this resolves the question. If not, please let me know.

Add 1 + 1: =1+1

Add the contents of cell A1 to the contents of cell B1: =A1+B1

Subtract 2 - 1: =2-1

Add the contents of cell A1 from the contents of cell B1: =B1-A1

Multiply 1 times 2: =1*2

Multiply the contents of cell A1 times the contents of cell B1: =A1*B1

I hope this resolves the question. If not, please let me know.

Aug 08, 2008 | Microsoft Computers & Internet

hm I dont think that is possible with a formula. I think you need to use Macro.

Jul 18, 2008 | Microsoft Computers & Internet

instead of validation use conditional formating (under format menu). If c1<1 format cell as red. It does not have the attention getter that validation does not require the active cell event. Every other option requires the cell become active for a test.

Apr 13, 2008 | Computers & Internet

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.

Nov 09, 2007 | Computers & Internet

using MS EXCEL:
start the operand with the following:
IF _<>_value is true, value is false
example: Not equal to A1<>B1, IF A1 not equal to B1

Sep 02, 2007 | Microsoft Office Standard for PC

Jan 28, 2016 | Microsoft Excel for PC

Dec 12, 2013 | Microsoft Excel for PC

Jul 23, 2013 | Microsoft Excel for PC

138 people viewed this question

Usually answered in minutes!

34+40

×