Need Help With ARRAY Formula

[cummingse]

1. During a four-week period, you worked the following hours, Week
(36
3/8 hr), Week 2 (41 1/4 hr), Week 3 (41 1/2 hr) and Week 4 (38 3/8 hr)
What
is the

average number of hours you worked in one week.

A 38 1/4 A FALSE
B 38 3/4
C 38 1/8
D 39 3/8
I have created a ARRAY Formula that if you select the wrong answe

it
retuns False, and if you select the correct answer it retuns True, Bu
the
problems is when the named cell (ANS) is blank it retuns FALSE, and
would
like it to be Blank (Empty). What do I need to add to this formula t
make
it show an empty cell when named cell ANS is empty.

 

[Bernie Deitrick]

How about this - all those extra "False" returns aren't needed, nor does it need to be array
entered:

=IF(ANS="","",IF(ANS=ANSD,"True","False"))

HTH,
Bernie
MS Excel MVP