need help with IF

  • Thread starter Thread starter Thad
  • Start date Start date
T

Thad

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?
 
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,"")
 
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.
 
Back
Top