need help giving a cell a value if certain text is in another cell

D

docspink

ok for example, if cell A1 contains the word "OFF" i want cell B1 to have a
value of 1, if not just to stay at 0, anybody know the formula
 
C

CyberTaz

You practically wrote it yourself:)

In cell B1 enter the following:

=IF(A1="Off",1,0)

This is just one option - depending on the overall design of your work there
could also be others.

HTH |:>)
Bob Jones
[MVP] Office:Mac
 
J

JE McGimpsey

CyberTaz said:
In cell B1 enter the following:

=IF(A1="Off",1,0)

This is just one option - depending on the overall design of your work there
could also be others.
Click to expand...

Just another option (that doesn't require a function):

B1: =--(A1="Off")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Newbie Help - IF Yes No Function 0
VBA Coding Help for Beginner 0
Excel - Wich Function should I use? 1
Word macro that can call cells out of Excel for a find and replace 0
Excel does not accept text format! 0
Autonumber field in Excel that behaves the same as Access 0
Help needed! Extracting Heading 3 and Contents from a Word Doc to Excel 0
Drop down list control value in vba 2

Top