number closest to zero, within limited range

[sebtaw]

Hi,


Im a medical student and for current research I've been trapped for some months due to my lack of knowledge in excel. So far, google or friends couldn't help me out on my specific issues. If there exists a formula out there, it would greatly reduce the amount of hours I spent on this research and spent them on more important parts of the research. Thanks in advance!


1. I'm looking for a formula that select the a number closest to zero, so that the cell next to this number will get a "1" instead of a "0"


2. I only want this number to be selected if the number falls within the range of -90 through 90. For example, if the number closest to 0 is 95, it should not be selected.


3. Here is the difficult part. My aim is to have this formula to select the number closest to zero, for each individual patient. In the file I uploaded, I have included 6 individual patients, numbered M1 through M6.

I can't seem to upload a file or an image somehow, so I uploaded the excel file in a google drive folder HERE


So basically I want a formula that, for each individual patient (M-number), I want the number closest to zero to be selected, as long as this number falls withing the range of -90 to 90. Any help is much appreciated!

 

[Joe4]

Duplicate: https://www.mrexcel.com/forum/excel-questions/1059451-number-closest-zero-within-range.html

Note that sometimes posts from new users require Moderator approval before you can see them on the public forums. When this happens, you should see a message to that effect when you try to post it. Please be patient and do not attempt to post the question again.