For # 1 try:

=IF(C22*44.5,C22*44.5,"Total Times 44.5")

For # 2 try:


=TEXT(TODAY(),"\T\o\d\a\y\s \D\a\t\e mmmm dd yyyy")

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"frankrizzo" wrote
in message ...

Hi all I am trying to figure out how to name a cell if it equals to
zero, forinstance =SUM(C22)*44.5 but if it equals zero I want to
display the words "Total Times 44.5"
I am also trying to center two cells or have one cell read =TODAY() But
that cell has to read "Todays Date July 28 2006"

Thanks


--
frankrizzo
------------------------------------------------------------------------
frankrizzo's Profile:
http://www.excelforum.com/member.php...o&userid=36897
View this thread: http://www.excelforum.com/showthread...hreadid=566110