Question about Business & Productivity Software

1 Answer

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

1 Answer

  • 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
  • 80 Answers

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

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

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

2 Answers

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

1 Answer

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

4 Answers

Using excel to solve problem by trial and error method


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

Mar 31, 2009 | Microsoft EXCEL 2004 for Mac

1 Answer

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

1 Answer

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

2 Answers

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

2 Answers

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

1 Answer

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 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 Business & Productivity Software

1 Answer

Help with simple excel calculations


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!

Jun 10, 2008 | Microsoft Excel for PC

Not finding what you are looking for?
Business & Productivity Software Logo

Related Topics:

92 people viewed this question

Ask a Question

Usually answered in minutes!

Top Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18299 Answers

Tony

Level 3 Expert

2598 Answers

Are you a Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...