Hi,

I need to understand how to manipulate text in formulas.

My problem is that if I have an...

amount biger than zero in (L14) whose formula is =+J14-I14-K14,

and

should I then type in text in P14, L14 will then return a zero, instea
of calculating =+J14-I14-K14 due to text typed in P14.

The manipulation will have to occur in L14 (my totals column for th
day)

eg. L14 calculates total (=+J14-I14-K14), but if I type "any text" i
P14, L14 = 0

Help will be most appreciated

--
Message posted from http://www.ExcelForum.com