need help with IF
 

please for give my novice: I need to do the following;

When I enter the word "contract" in A1 I need the word "Barre" to appear in
C1, todays date to appear in D1 and the number "17" to appear in E1. (this
worksheet is a mileage inventory and Barre is the most used location)

I have tried to use the help manual but it does seem to give me enough
information, because I seem to error every formula I try.

Cab anyone help me write this formula?

need help with IF
 

Presumably you want your result cells to be blank if no "contract" in A1?

In C1, use the formula =IF(A1="contract","Barre","")
In D1, =IF(A1="contract",TODAY(),"") but remember that this will change
tomorrow. More complicated if you want it to stay showing the date that you
*first* entered "contract" in A1.
In E1, =IF(A1="contract",17,"")
--
David Biddulph

"Thad" wrote in message
...
please for give my novice: I need to do the following;

When I enter the word "contract" in A1 I need the word "Barre" to appear
in
C1, todays date to appear in D1 and the number "17" to appear in E1. (this
worksheet is a mileage inventory and Barre is the most used location)

I have tried to use the help manual but it does seem to give me enough
information, because I seem to error every formula I try.

Cab anyone help me write this formula?

need help with IF
 

Hi Thad,

In B1 enter..

=IF(A1="Contract","Barre","")

In C1 enter...

=IF(A1="Contract",TODAY(),"")

In D1 enter...

=IF(A1="Contract","17","")

Hope this helps,

Gav.

"Thad" wrote:

please for give my novice: I need to do the following;

When I enter the word "contract" in A1 I need the word "Barre" to appear in
C1, todays date to appear in D1 and the number "17" to appear in E1. (this
worksheet is a mileage inventory and Barre is the most used location)

I have tried to use the help manual but it does seem to give me enough
information, because I seem to error every formula I try.

Cab anyone help me write this formula?