Numbers and an "IF" statement?

Question

Level 1

4 points

Numbers and an "IF" statement?

Ok so here is my problem. I have a home test i am taking for school and i want it to correct my answers automatically. In column "A" i have numbers 1-30 in column "B" i am typing my answer A-D. Is there a formula to use to do this? I would like it to show in column "C" the correct answer and change column "B" red if at all possible. I have taken C++ programing and Excel programing but Numbers is still new to me. Thanks for your time

MacBookPro4,1, Mac OS X (10.6.2)

Posted on Jan 17, 2010 9:11 PM

Reply

Answer 1

KOENIG Yvan

Level 8

41,845 points

Jan 17, 2010 11:17 PM in response to Firkins_AJ

Welcome to the club.

It would be useful to study the PDFs Numbers User Guide and iWork Formulas and Functions User Guide which may be downloaded thru the Help menu.

The formula :
=IF(A<5,"A",IF(A<10,"B",IF(A<15,"C","D")))

is a good starting point.

Yvan KOENIG (VALLAURIS, France) lundi 18 janvier 2010 08:17:40

Reply

Answer 2

Badunit

Level 7

31,341 points

Jan 18, 2010 7:19 AM in response to Firkins_AJ

I may be misunderstanding what you want but here is a start. To make it easier to do the conditional formatting of 30 rows, I suggest putting the color in column C, not column B. If the formatting is in column B you will have to manually edit all 30 of them. In column C, you can copy/paste the format to all the rows.

1. Put the correct answers in column D. You will hide this column after everything is set up.

2. In C1 put the formula =IF(B="","", IF(B=D,D,D&" ")) . This will make C1 blank until an answer is typed into B1. Then it will provide the correct answer (with a single space appended to the end if B has an incorrect answer).

3. Create a conditional format for C1 that is "if text contains a space then fill red".

4. Drag-fill or copy/paste C1 to the rest of the column.

5. Hide column D

Reply