Text and the #VALUE error

H

Harry Garrett

Is there a way that you can use text in a cell that is part of a formula
such that the formula returns 0 instead of a "#VALUE" error?

I would like to be able to insert memos for extraordinary events which would
be displayed with the rest of the sheet.

Thanks

Harry
 
D

Dave R.

What formula are you using now? Some functions like average and sum (in
simple form) will ignore cells that contain text, but apparently your
formula is returning #VALUE when you enter text.
 
B

Bob Phillips

=IF(ISERROR(formula),"",formula)

perhaps?

--

HTH

RP
(remove nothere from the email address if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Use TODAY() function as the criteria in a SUMIF formula 1
Creating a Chart on form from selected data in query. 0
Searching the formula (not the value) for a text string 1
Excel does not accept text format! 0
Copy addition formula of non-consecutive horizontal cells 2
VBA to see if a Section exists in Word Document, and if it does, delete it 2
Vlookup and return sheet name also 2
SUMPRODUCT formula I think w/ wild card & number vs number as text 8

Top