If statement

[=?iso-8859-1?B?QW5kcuk=?=]

Is there a way to have an if forumla populate a cell if
another has data in it?
i.e. =if(c3=x, a2+1,"blank")

so if c3 = any data text or otherwise a3 would equal a2+1
and if there was nothing in c3 then the cell is left blank.

Is there a way to do this?

A.

 

[Jim]

=IF(C3=YourCriteria, A2+1,"")

 

[=?iso-8859-1?B?QW5kcuk=?=]

My criteria is that the cell contain information. I'll be
inputing names into that cell range and so I would like it
to recognize that the cell is no longer blank. Is that
possible?

A.

 

[Paul]

=IF(ISBLANK(C3),"",A2+1)
or
=IF(C3="","",A2+1)


My criteria is that the cell contain information. I'll be
inputing names into that cell range and so I would like it
to recognize that the cell is no longer blank. Is that
possible?

A.

 

[Jim]

=IF(C3<>"", A2+1,"")


--
Greeting from the Gulf Coast!
http://myweb.cableone.net/twodays
My criteria is that the cell contain information. I'll be
inputing names into that cell range and so I would like it
to recognize that the cell is no longer blank. Is that
possible?

A.

 

[=?iso-8859-1?B?QW5kcuk=?=]

Thanks Paul, that first one works just fine.

Do you know if the same principal can be used to have the
cells in column B insert the date? I know of the (now)
feature (i think that's it) for the date but would that
make the date in the cell change every time the document
is opened?

A.

 

[Paul]

You can use
=IF(ISBLANK(C3),"",TODAY())
to show the current date if C3 is not blank. (Note that NOW() shows date and
time, not just date.)
However, as you say, each time you open the document the date you see will
be the current one - not the one when C3 ceased to be blank. If you didn't
want the date to change like this, you would need a macro to automatically
insert a fixed date on the occurrence of an event (C3 ceasing to be blank).
Note that you can manually insert today's date in a fixed form using CTRL+;
(hold down CTRL whilst pressing semicolon).

Thanks Paul, that first one works just fine.

Do you know if the same principal can be used to have the
cells in column B insert the date? I know of the (now)
feature (i think that's it) for the date but would that
make the date in the cell change every time the document
is opened?

A.