Works perfect! Never would have know about "iferror" OR "ifnumber" unless you
told me. How can I get a list of these and define their uses.

Another question to perfect this work book: Based on my previous question,
If cell B40 is displaying an error: #div/0! and I wish for it to not print.
How do I put in the formula into B40: =average(B2:B38) PLUS have that cell
not print anything if there is an error. This is all remembering that there
are other cells on other work sheets that will be referencing this sheet1!B40.
--
Melody


"T. Valko" wrote:

Try this:

=IF(ISNUMBER(Sheet1!B40),Sheet1!B40,"WORD")

--
Biff
Microsoft Excel MVP


"Melody" wrote in message
...
If cell B40 contains a formula to AVERAGE the adjacent cells (B1:B38),
however, this range of cells are empty, then my result in cell B40 equals
#DIV/0!

Now, on the next worksheet, I would like cell C50 to reference B40,
however,
if B40 does not give me a result (if it says #DIV/0!) then I would like
for
cell C50 to give me a "WORD".

However, if any values have been entered into cells (B1:B38) and
therefore
I do get a result in cell B40, then I would like it to also result in cell
C50 on the next work sheet.

My problem is if I use the Function IF in cell C50, I cannot say:
Logical_test: IF B40 < #DIV/0!
Value_if_true: =AVERAGE (B1:B38)
Value_if_false: "WORD"
How can I have cell C50 perform a formula only when cell B40 gives me a
result?--
Melody