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 has exceeded 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!
Hello
If your value was for example in A1:
If the cell is empty or equal to 0.05 then it returns empty.
Please Login or Register to view this content.
Hope this helps.
DBY
You don't say what to do if the value is equal to .05 so I included it with the values >.05
Formula:
Please Login or Register to view this content.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
@DBY - surely the "AND" is superfluous, as the cell cannot be both blank, AND have a value?
I think a more straightforward approach would be:
Please Login or Register to view this content.
@Boosted7 - please note that a cell value of 0.05 is not catered for in the information you have provided.
Brendan.
__________________________________________________________________________________________________
Things to consider:
1) You can thank any poster by clicking the * at the left of a helpful post.
2) You can help to keep the forum tidy by marking your thread as "Solved", if it has been answered to your satisfaction.
3) Help us to help you, by uploading a sample workbook, showing the type of data you're dealing with, and clearly indicating what the results should be.
@Brendan, the OP requested that the formula return a '0' if the value was less than 0.05. Without the 'And' criteria it returned a '0' if blank, which I assumed wasn't wanted. Your formula returns only blank or False.I think it's all academic anyhow as Boosted7 has not acknowledged any of our replies. So perhaps all are unsuitable.
DBY
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks