Thread
:
Cel values help needed
View Single Post
#
3
Posted to microsoft.public.excel.worksheet.functions
Don Guillett
external usenet poster
Posts: 10,124
Cel values help needed
=IF(LEN(TRIM(H17))<1,"no","yes")
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Tim Turner" wrote in message
...
i have a spreadsheet to compare inputed predicted and actual values
(football
scores that are predicted against actual results) and return a score.
Excel
appears to treat an empty cell as a zero value, how can an empty cell be
flagged as "empty" and prevent the calclation taking place untill a value
is
entered.
Any help gratefully accepted
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett