Can I enter a particular text in cell linked through a number? i.e. my cell B1 should contain "lemon" if I enter 1 in cell A1, "mango" if enter 2 in cell A1 and other such texts linked with particular numbers.

Ad

You can give the formula by the lookup function

at first make the lists in an another sheet e.g. in sheet2 write the following entries for reference :

a1 b1

------------------

1 lemon

2 mango

3 papaya

4 pear

5 orange

6 apple

7 banana

then in sheet1 write the following formula in cell b1

=LOOKUP(A1,Sheet2!A1:B7)

then enter the num upto the limit of lists.

the cell b1 will take values from the reference cell of sheet2

your problem must will be solve.

Posted on Aug 08, 2008

Ad

Yes, its possible by designing a formula in excel.

Posted on Aug 03, 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

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.

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.

May 17, 2014 | Computers & Internet

Hi sug04

These are couple of solutions

First. Solution

Good luck, have a nice day

Please give a Rating to this solution

luciana44

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

- 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

Sep 17, 2009 | Microsoft Excel for PC

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

Assumption:

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

- we work on
**sheet1**, cell**b1**as description of material and cell**e1**as quantity figure. - 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.

The formula will check

If you want some text will display when there's no value in

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

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

Mar 12, 2009 | Microsoft Windows Vista Home Basic for PC

No tmaking promises but try pushing F9 and for future make sure the Automatic caluculation is turned on.

Nov 26, 2008 | Microsoft Excel for PC

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

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:

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

Then the following answers will appear in the D column:

Sep 29, 2008 | Microsoft Computers & Internet

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

Just follow the steps....

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

- Select B2 Cell
- Right Click and goto Format Cell
- Goto Number
- Under Number select Number Catogory
- and then select 2 decimals

Jan 31, 2008 | Computers & Internet

Mar 05, 2014 | Microsoft Windows XP Professional

Feb 19, 2014 | Microsoft Windows XP Professional

Feb 17, 2014 | Microsoft Windows XP Professional

132 people viewed this question

Usually answered in minutes!

×