Microsoft 365 and Office | Development | Other
Building custom solutions that extend, automate, and integrate Microsoft 365 apps.
Not sure quite what you're looking for but if makes sense here.
=IF($A$1 > 50, 0, 1)
Convert multiple numbers into 0/1
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(147.20000000000002, 40%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
ANTONIO MIELE
1
Reputation point
hi everyone, I need your help.
I would like to convert all values from 1 to 50 in a column into 1 an other column and all tue values greater than 50 into 0, can I with a simple formula or whatever?
Microsoft 365 and Office | Development | Other
Microsoft 365 and Office | Excel | For business | Windows
Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
{count} votes
-
Emi Zhang-MSFT 30,126 Reputation points Microsoft External Staff2022-06-06T09:37:30.413+00:00 Hi @ANTONIO MIELE ,
Just checking in to see if the information was helpful. Please let us know if you would like further assistance.
If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Sign in to comment
2 answers
Sort by: Most helpful
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(256, 32%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMT%3C/text%3E%3C/svg%3E)
Michael Taylor 61,106 Reputation points2022-05-31T17:54:31.75+00:00 -
Emi Zhang-MSFT 30,126 Reputation points Microsoft External Staff
2022-06-01T06:45:46.35+00:00 Hi @ANTONIO MIELE ,
Try this formula:=IF(A1>50,0,IF(AND(A1>0,A1<=50),1,""))
If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.