How can I get text to equal a numerical value in Excel?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am developing a scheduling program for my workplace. The program will
automatically calculate total time scheduled based on times entered (i.e.,
8:00AM start time in one cell, 5:00PM end time in the next cell calculates to
9 hours in a third cell). However, we need to indicate days off, vacations
and leaves of absences. When we enter text into the first cell, it obviously
destroys the calculation in the third cell. I need to be able to have Excel
assign a value of "0" for any cell that has text. Thanks, Mike
 
Mike,
I fixed similar problems in my files by using the if & iserror
functions. For example, if(iserror(a1+b1),0,a1+b1).

I may not have the exact formatting for the iserror portion but it
should be close.
 

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

Excel cell value equals selected text from Word 2
how do I test for a text value in cell c1, if it is there, make c. 1
Ignore text but count values in same cell 2
I displaying a range in Time within a cell in Excel. 1
A function to Turn Formula into Text? 24
Adding text to equal text 3
adding text according to col with equal date 2
Excel Stop Excel from displaying rounded values 4

Back
Top