Sum; If; IsText

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

Guest

I downloaded the Excel template for the Employee Shift Schedule. It is a really good spreadsheet, but the time is entered in 1 hr increments and I need 1/2 hr increments. I tried changing the 1 to a .5, but that gave me a result of 0. I have tried creating the formula myself, but am not very good with that kind of formula. I want it to be the same formula (ie. if there is text in certain cells it will equal .5, if not it will equal 0), but don't know how to create it or fix the current one. Any suggestions?
 
Further detail (viz.,a formula, and the contents of cells referred to in the
formula) may be required.


Tonya said:
I downloaded the Excel template for the Employee Shift Schedule. It is a
Click to expand...
really good spreadsheet, but the time is entered in 1 hr increments and I
need 1/2 hr increments. I tried changing the 1 to a .5, but that gave me a
result of 0. I have tried creating the formula myself, but am not very good
with that kind of formula. I want it to be the same formula (ie. if there
is text in certain cells it will equal .5, if not it will equal 0), but
don't know how to create it or fix the current one. Any suggestions?
 
The formula that is in the cell for the worksheet is =SUM(IF(ISTEXT(D14:Z14),1,0)) I tried to change the 1 to a .5, but that didn't work. I also tried to rewrite the formula using .5 and it still did not work. If you need more info to help me, please let me know and I'll try to get it to you
Thanks!
 
For starters, that formula needs to be entered with CTRL SHIFT ENTER or it
will return 0. It counts the text entries in D14:Z14.
If that doesn't work, please provide what can be contained in D14:Z14 and
what you would like as a result.

Hope it helps.



Tonya said:
The formula that is in the cell for the worksheet is
Click to expand...
=SUM(IF(ISTEXT(D14:Z14),1,0)) I tried to change the 1 to a .5, but that
didn't work. I also tried to rewrite the formula using .5 and it still did
not work. If you need more info to help me, please let me know and I'll
try to get it to you.
 
Back
Top