help with functions
 

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

help with functions
 

frankrizzo,

1] Probably an =IF() will do here, see #2 for additional guidance

2] Enter somewhere ="Today "&TODAY()
see what you get...


Beege


"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

help with functions
 

Hi Frankrizzo,

It is not clear whether you want to add or multiply, however you can
use it as

=if(SUM(C22)*44.5=0,"Total Times 44.5",SUM(C22)*44.5)

It will display if the "Total Times 44.5" when formula equals to zero
otherwise C22 * 44.5

Hope this works for you

Thanks

Shail


frankrizzo wrote:
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

help with functions
 

For the first part of your question you can use an IF statement as
follows:

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

For the second part you can use a custom format. Select Format Cells
select Number tab at top of dialog box, Select Date from the Category
list and select "March 14, 2001" from the Type list box. Then select
Custom from the Category list (this will allow you to modify the format
you previously chose). In the Type box that appears you should insert
before the format scheme this exact text including quotes "Todays Date
" and then click OK.



frankrizzo Wrote:
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


--
Excelenator


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

help with functions
 

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