# Microsoft excel what i want to do is if i put number 1 into cell b1 is it possible that excel can automatically put say £50 into cell d2, then say i put number 2 into b2 then put £25 into d2, any help much appreciated

Posted by on

• Level 2:

An expert who has achieved level 2 by getting 100 points

Hot-Shot:

An expert who has answered 20 questions.

Corporal:

An expert that has over 10 points.

Mayor:

An expert whose answer got voted for 2 times.

• Expert

This is done through formulas. You write them in relationship to one another. Say you put a value into B1 then you write a formula for c2 like =SUM(A1/2)which means the sum of A1 divided by 2. or you can say make a formula that is like this =SUM(A1/C1) which means the value of A1 divided by the value of C1.

Posted on Jan 10, 2009

Hi,
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).
goodluck!

Posted on Jan 02, 2017

×

my-video-file.mp4

×

## Related Questions:

### How do i select the lowest 3 numbers from a list of 4 numbers

type =MIN(B1:B4). if the 4 numbers is in the cell b1 to b4, else, name the cell number.

Nov 15, 2011 | Microsoft Excel for PC

### What is the formula of finding the percentage in a microsoft excel

Assume
A1=50
B1=100
In C1 use the formula: =SUM(A1/B1)

Then format the cell to % as follows:
Right click the cell, select FORMAT CELLS; on the NUMBER tab select percentage.

Now it will show 50%

Sep 14, 2010 | Microsoft Xbox 360 Console

### Text within an IF formula

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.

May 20, 2009 | Microsoft EXCEL 2004 for Mac

### I have some value in Sheet2 of an xls file. now i want to link that value to a cell in Sheet1. Hence, if theres any change of value in sheet2 it also do reflect in Sheet1

Just put the following formula in the cell you want the number to change.
=sheet2!b1 the B1 is the cell on sheet 2 or whatever cell you want to link to. Whatever you put in cell B1 on sheet 2 will automatically change on the cell on sheet one you place this formula in.

Apr 24, 2009 | Microsoft Excel 2003 (065-03992) for PC

### How to convert number to caror

if you want to do it in the same cell you can do it wit auto correct option. It's under menu - tools - autocorrect. On the replace part put 100,00,000 and the "with" box put carol and click okay. If you want to do it in a different cell you can use "if" function. Lets say A1 has the value of 100,00,000 and on the cell B1 you type =if(a1=100,00,000, carol,"") so if A1 is 1000,00,000 B1 will show carol otherwise it'll show nothing.

Feb 27, 2009 | Microsoft Excel for PC

### Multiply a value by a minimum amount

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.

Feb 24, 2009 | Microsoft Excel for PC

### Excel farmulas

Add another colum, say D with result of B*C

Do a list of the different cat, and use sumif
For cat 0101 (in cell F1)
formula to put in G1
=sumif(\$A\$1:\$A\$7000;F1;\$D\$1:\$D\$7000) where F1 contain 0101

expand the formula for other cat. (G2, G3, etc)

You can use a assistant to extract the distinct cat from A1:A7000, sorting them and copy the result in F (Menu Data-> Filter -> elaborate filter)

Feb 16, 2009 | Microsoft Excel for PC

### Formula help

You should either use this formula to remove 46% from 328.06. The first option is =B1-(B1*C2) wherein you should deduct 46% from B1 or just compute for the 54% of B1 which is =B1*56%.

Jan 22, 2009 | Microsoft Excel for PC

### Computer

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 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

### Regarding Excel formulas

Yes, its possible by designing a formula in excel.

Aug 03, 2008 | Microsoft Windows XP Professional

## Open Questions:

#### Related Topics:

92 people viewed this question

Level 3 Expert

Level 3 Expert