help with functions

[frankrizzo]

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

 

[Beege]

frankrizzo,

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

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


Beege

 

[shail]

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

 

[Excelenator]

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.

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

 

[Ragdyer]

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")