Need Help With ARRAY Formula

C

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
Click to expand...
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.
 
B

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
 
Top