Question about Microsoft EXCEL 2004 for Mac
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 :
but a #VALUE appears in B1.
If anyone can help me?
Thanks in advance,
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
I came up with this:
Works fine for me.
Posted on May 22, 2009
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.
Posted on Jan 02, 2017
Tips for a great answer:
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.
Aug 19, 2011 | Microsoft EXCEL 2004 for Mac
on Nov 11, 2013 | Microsoft Excel Computers & Internet
Sep 16, 2009 | Microsoft Office Excel 2007
Mar 31, 2009 | Microsoft EXCEL 2004 for Mac
Mar 12, 2009 | Microsoft Windows Vista Home Basic for PC
Jan 10, 2009 | Computers & Internet
Aug 08, 2008 | Microsoft Computers & Internet
130 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: