Question about Microsoft EXCEL 2004 for Mac

2 Answers

Text within an IF formula

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





Posted by on

  • jacques_bois May 21, 2009

    Wow! 3 hours of searching fixed in two sentences.


    Thanx alot.

×

2 Answers

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Vice President:

    An expert whose answer got voted for 100 times.

  • Master
  • 864 Answers

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

  • Level 1:

    An expert who has achieved level 1.

  • Contributor
  • 1 Answer

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

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

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).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

2 Answers

What are the formulas in grading the grades uisng microsoft excel


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.

  1. All formulas begin with an equals sign (=).
  2. 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.
  3. 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.
  4. 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.
  5. 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

3 Answers

Can't see coordinates in Excel Formulas


And this is when you have selected a box and simply type something ?

Dec 28, 2007 | Computers & Internet

Tip

HOW TO COUNT THE OCCURRENCES OF A TEXT STRING


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*")

on Nov 11, 2013 | Microsoft Excel Computers & Internet

3 Answers

How do i insert a formula in a column to add each number & give a total at the bottom?


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

That should do it. :)

Sep 16, 2009 | Microsoft Office Excel 2007

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

Finding the right formula


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.
1ak+f4pj7cbm32cuniyi2gaaaaaelftksuqmcc

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

1 Answer

Microsoft excel


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

6 Answers

EXCEL FORMULA NOT WORKING


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

Nov 26, 2008 | 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 Computers & Internet

2 Answers

Regarding Excel formulas


Yes, its possible by designing a formula in excel.

Aug 03, 2008 | Microsoft Windows XP Professional

Not finding what you are looking for?
Microsoft EXCEL 2004 for Mac Logo

130 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2658 Answers

Piyal Perera
Piyal Perera

Level 3 Expert

528 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18389 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...