+ Reply to Thread
Results 1 to 2 of 2

If value greater than 0.05, then write a value of 1 in adjacent cell

  1. #1
    Registered User
    Join Date
    09-27-2012
    Location
    Cambridge, England
    MS-Off Ver
    Excel 2010
    Posts
    9

    If value greater than 0.05, then write a value of 1 in adjacent cell

    Hello,
    Sorry I am a complete noob when it comes to Excel and I'm in some serious need of help with what I believe is a fairly simple thing:

    I have a column full of values, and I am interested to know whether each of the values is equal to or greater than 0.05. I would like to write a formula so that in the adjacent column, it can simply place a "1" in the cell of the value adjacent to it is greater than 0.05, and a "0" if it is less than 0.05.

    Can someone help me please?

    Thanks!

  2. #2
    Forum Contributor
    Join Date
    07-24-2012
    Location
    Denver, CO
    MS-Off Ver
    365
    Posts
    230

    Re: If value greater than 0.05, then write a value of 1 in adjacent cell

    If your data is in column A, stick this in cell B1 and drag it down to the bottom of your data

    =IF(A1>0.05, 1, 0)
    ~~LaffyAffy13~~

    If I have helped you solve your problem, please be sure to click at the bottom left of my post.

    Thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 4
    Last Post: 07-29-2013, 12:35 PM
  2. range find data and write to adjacent cell
    By cdy3900 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-18-2013, 11:32 PM
  3. Fill Series if adjacent cell value is greater than zero
    By maxflower in forum Excel General
    Replies: 2
    Last Post: 02-12-2012, 07:20 PM
  4. Userform Find Cell from ComboBox Value and write to adjacent cell
    By msommerf in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-27-2010, 11:38 AM
  5. VB - Write in adjacent cell given certain criteria
    By adgjqetuo in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-26-2009, 01:07 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1