Text and the #VALUE error

  • Thread starter Thread starter Harry Garrett
  • Start date Start date
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
 
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.
 
=IF(ISERROR(formula),"",formula)

perhaps?

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
You must log in or register to reply here.

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

Searching the formula (not the value) for a text string 1
Excel formula, sum the value cell and if empty cell left blank 0
Vlookup and return sheet name also 2
=IF(I2="",IF(F3>0,F3,""),IF(F3>0,(F3+1)*(I2+1)-1,"")) ERROR?? 0
SUMPRODUCT formula I think w/ wild card & number vs number as text 8
Reference text in a cell inside a formula to specify a sheet name 4
#value error for sumproduct using RIGHT cmd 0
With F1 value, look at A, if match or partial match return B 5

Back
Top