Thread
:
Excel Formula add if someone types PTO have it =0
View Single Post
#
4
Posted to microsoft.public.excel.worksheet.functions
RagDyeR
external usenet poster
Posts: 3,572
Excel Formula add if someone types PTO have it =0
Use the SUM() function!
It ignores text.
=Sum(A1:A110,B5:B15)
=Sum(A1,A33,B4,C2,C25,Z15)
--
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"John Krsulic" <John
wrote in message
...
I am trying to create what I would call an if/then formula in Excel 2003.
If
someone types the letters PTO into a cell have tat equal zero in the
formula.
I have a sum formula of a set of cells I want Excel to be able to add a
zero
into the formula if someone types the letters PTO into the cell. My
formula
works great until someone types letters into a cell then - of course -I
get a
value error in the cell.
Reply With Quote
RagDyeR
View Public Profile
Find all posts by RagDyeR