Column with text "On" or "Off" want to make 0 or 1.

[WillBergstein]

Basically the title. I want to plot time of day over several days, versus whether a machine is "on" or "off". I want to convert the "on" and "off" terms into 0 or 1.

[rcm]

without a sample is a guessing game but assuming there are two columns date and state of the machine in columns A and B respectively I would suggest another column C with a =if(B..="on",1,0) and copy it all the rest of the data rows.

[Xx7]

You could select the On/Off column, press Ctrl+H... search and replace all On's with 1's and Off's with 0's

[David A Coop]

Hi Will,

Welcome to the forum!

Are you comfortable with a "helper" column to give you the 0s and 1s?

Suppose A1 = "Off" In B1 type =(A1 <> "Off")*1 This assumes that Off is 0 and On is 1. Otherwise, reverse the logic.

There are many other ways to do this with a helper column!

Regards, David



When you reply please make it clear WHO you are responding to by mentioning their name.
If this has been of assistance, please advise. A little thanks goes a long way.
- Please click on the *Add Reputation button at the bottom of helpful responses.
Please mark your thread as SOLVED:
- Click Thread Tools above your first post, select "Mark your thread as Solved".

[popipipo]

=--(A1="on")
or try this one