Regarding Excel formulas

Excel formulas really haven't changed at all, so any information you find on newer version of Excel will most likely apply to 2007.
However, to answer your question, let's look at the following scenario:
If A1 and B1 both have numbers and you want the cell C1 to be the result of adding A1 and B1, select the cell C1 and type "=SUM(A1:B1)" (without the quotation marks)
You can also do this by just typing "=SUM(" in C1 and then click and hold your mouse button on A1 and select B1 as well. Then close the parenthesis and press Enter. Done!

Hope this helps.

Hi sug04
These are couple of solutions
First. Solution

• Take away 20% means the answer is 80%
  
• 20% means 0.2 of a number, 80% means 0.8 of a number
  
• So If you have 200 in Cell B1
• And you want 20% less in B2
• Goto B1 type 200
• Goto B2 type like this =B1*.8 and press ENTER
• Now Cell B2 displays 160 which is the correct answer

Second Solution

• Goto B1 type 200
• Goto B2 type like this =B1-(B1*.2) and press ENTER
• Now Cell B2 displays 160 which is the correct answer

Good luck, have a nice day
Please give a Rating to this solution
luciana44

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.

Assumption:

1. we work on sheet1, cell b1 as description of material and cell e1 as quantity figure.
2. we will put the transfer the text in cell b1 to sheet2 cell a1 if you have entered some value in sheet1 cell e1. Otherwise sheet2 cell a1 will left empty or display some text as "NONE" or as you wish.

what you should do is make a formula in sheet2 cell a1 like this:

=IF(Sheet1!e1<>"",Sheet1!b1,"")

The formula will check sheet1 cell e1, if there is any number or text put in there, the value of Sheet1 cell b1 will be copied to sheet2 cell a1. If you don't supply any number or text in sheet1 cell e1, there's nothing will appeared in sheet2 cell a1.

If you want some text will display when there's no value in sheet1 cell e1 just change the formula like this:

=IF(Sheet1!e1<>"",Sheet1!b1,"NONE")

You can modify it as your like. Just copy the formula to another row in sheet2 column a.


P.S.: If this information was helpful, please rate this solution.

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.

Are you looking to solve any particular problem?--- because there are a huge number of possible formulas in Excel.

However, in my opinion, the most commonly needed ones are addition, subtraction, division, multiplication, and summing.

Suppose you have the following numbers typed into your Excel spreadsheet:

columns: A B C D
rows
1 20 3
2 10 4
3 15 2
4 1 2 3


Then suppose you type in the following formulas (in the D column):

columns: A B C D
rows
1 20 3 =A1+B1
2 10 4 =A2-B2
3 15 2 =A3*B2
4 1 2 3 =sum(A4:C4)


Then the following answers will appear in the D column:

columns: A B C D
rows
1 20 3 23
2 10 4 6
3 15 2 30
4 1 2 3 6

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.

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

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.

Just follow the steps....

1. Type "Enter Land in Gundas" in A1
2. Type "Equivalent Land in Acres" A2
3. Type "=B1/40"
4. Now type the number of gundas in B1 example 100
5. you will automatically get 2.5 in B2

Now you need only two decimals tighy?

1. Select B2 Cell
2. Right Click and goto Format Cell
3. Goto Number
4. Under Number select Number Catogory
5. and then select 2 decimals

Thats all