Hi,

Here is an example of what I want to do (Excel 2004 Mac).

If I put the number 1 in a cell (A1) I want the word GOOD to appear in cell (B1), if I put the number 2 in A1 I want the word FAIR to appear in B1 and if I put 3 in A1 I want the word BAD to appear in B1.

I tried something like this :

=IF(G3=1;"GOOD)+IF(G3=2;"FAIR")+IF(G3=3;"BAD")

but a #VALUE appears in B1.

If anyone can help me?

Thanks in advance,

Jacko

Ad

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.

Posted on May 20, 2009

Ad

I came up with this:

=IF(A1=1,"Good",IF(A2=2,"Fair",IF(A3=3,"Bad","Wrong")))

Works fine for me.

Posted on May 22, 2009

Ad

Formulas are used to specify calculations based on values in designated cells. Excel supports basic calculations as well as statistical, trigonometric and other specialized functions.

Formulas used in Excel must follow a certain syntax.

- All formulas begin with an equals sign
**(=)**. - Some formulas use operands such as
**+,-, *,/**for addition, subtraction, multiplication or division.

For example, the formula =A1+A2+A3 would add the contents of cells A1, A2 and A3. - Other formulas refer to different functions such as SUM, AVERAGE and others.

For example, the formula =SUM(A1:A3) would add the contents for the range A1 through A3. - Formulas can be
**combined with operands.**

For example, the formula =10*SUM(A1:A3) would add the contents cells A1 through A3 and multiply them by 10. - Functions can
**be nested within each other.**

For example, the formula =SQRT(10*SUM(A1:A3)) would take the square root of ten times the sum of cells A1 through A3. When functions are nested, it is important that the number of left parentheses match the number of right parentheses.

Aug 19, 2011 | Microsoft EXCEL 2004 for Mac

In the cell that you
want the result to appear in, enter the appropriate formula from the following
examples.

How to Count the Occurrences of a Number

Use this formula

=SUM(IF(range=number,1,0))

where range is the range that you want to search, and number is the number that you want to count.

NOTE: This formula must be entered as an array formula. To enter an array formula, press CTRL+SHIFT+ENTER.

How to Count the Occurrences of a Text String

Method 1

Use this formula

=SUM(IF(range="text",1,0))

where range is the range that you want to search, and text is the text that you want to find (the text must be enclosed in quotation marks).

NOTE: The above formula must be entered as an array formula. To enter an array formula, press CTRL+SHIFT+ENTER.

Method 2

Use the COUNTIF() function to count the occurrences of a text string. For example, use the formula

=COUNTIF(range,"text")

where range is the range of cells that you are evaluating, and text is the text string that you want to count instances of (note that text must be enclosed in quotation marks).

NOTE: This formula must be entered as an array formula. To enter an array formula, press CTRL+SHIFT+ENTER.

Wildcard characters can be used within the COUNTIF function.

The asterisk character (*) represents more than one character. For example, to count all the cells in the range a1:a10 that contain an "x," you can use the following formula:

=COUNTIF(a1:a10,"*x*")

The question mark character (?) can also be used to represent one wildcard character -- for example, to count all cells in the range whose second character is the letter, such as "ax" or "bx."

=COUNTIF(a1:a10,"?x*")

How to Count the Occurrences of a Number

Use this formula

=SUM(IF(range=number,1,0))

where range is the range that you want to search, and number is the number that you want to count.

NOTE: This formula must be entered as an array formula. To enter an array formula, press CTRL+SHIFT+ENTER.

How to Count the Occurrences of a Text String

Method 1

Use this formula

=SUM(IF(range="text",1,0))

where range is the range that you want to search, and text is the text that you want to find (the text must be enclosed in quotation marks).

NOTE: The above formula must be entered as an array formula. To enter an array formula, press CTRL+SHIFT+ENTER.

Method 2

Use the COUNTIF() function to count the occurrences of a text string. For example, use the formula

=COUNTIF(range,"text")

where range is the range of cells that you are evaluating, and text is the text string that you want to count instances of (note that text must be enclosed in quotation marks).

NOTE: This formula must be entered as an array formula. To enter an array formula, press CTRL+SHIFT+ENTER.

Wildcard characters can be used within the COUNTIF function.

The asterisk character (*) represents more than one character. For example, to count all the cells in the range a1:a10 that contain an "x," you can use the following formula:

=COUNTIF(a1:a10,"*x*")

The question mark character (?) can also be used to represent one wildcard character -- for example, to count all cells in the range whose second character is the letter, such as "ax" or "bx."

=COUNTIF(a1:a10,"?x*")

on Nov 11, 2013 | Microsoft Excel Computers & Internet

You can do this pretty easily in a spreadsheet program such as excel, open office or numbers on a mac. Simply use two cells for the numbers you would like as an input and then input formulas for the sum, difference, product and quotient in 4 other cells. Examples:

(This assumes you use A1 and B1 to hold your input numbers)

For sum you would input the formula: =A1+B1

For difference: =A1-B1

For product: =A1*B1

For quotient: =A1/B1

To get this into a flowchart simply go into "Insert > Chart" and select the chart you want to use with the correct options.

*I hope this helps, if it does, please give a thumbs up!*

(This assumes you use A1 and B1 to hold your input numbers)

For sum you would input the formula: =A1+B1

For difference: =A1-B1

For product: =A1*B1

For quotient: =A1/B1

To get this into a flowchart simply go into "Insert > Chart" and select the chart you want to use with the correct options.

Jun 28, 2011 | Computers & Internet

For example, you have three numbers from A1 to A3. On row A4, type =SUM(A1:A3).

That should do it. :)

That should do it. :)

Sep 16, 2009 | Microsoft Office Excel 2007

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

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

the basic idea of an if statement is just that if this then that. Thus a formula could look as simple as =IF(A2=1,25,IF(A2=2,10))

Jan 10, 2009 | Computers & Internet

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.

Jan 10, 2009 | 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

Yes, its possible by designing a formula in excel.

Aug 03, 2008 | Microsoft Windows XP Professional

May 10, 2021 | Computers & Internet

May 06, 2021 | Computers & Internet

140 views

Usually answered in minutes!

Wow! 3 hours of searching fixed in two sentences.

Thanx alot.

×