How to create a IF cell contains Yes, add Moderate to another cell.

I am a medical student (so not very tech savvy) and currently doing a research on COVID-19 severity

I have data of over 100,000 patients. In the data I have, a column G is named Symptomatic which contains values "Yes" or "No" or "Unknown"

I have created another column F that says Severity, I want the column to automatically contain "Mild" if column G says No and automatically contain "Moderate" if column G says Yes.

The columns are shown in the picture. I did these manually to give an idea of what I want.
Untitled.jpg

I wanted to know if there can be a formula that can automatically do this for me since its data of 100,000 patients and I will keep receiving more.

Try this in F2:

IF(G2=No","Mild",IF(G2="Yes","Moderate","Other"))

then copy it down by double-clicking the Fill Handle (the small black square in the bottom right corner of the cursor), with F2 selected.

Note that the Other comment covers situations where column G cells do not contain Yes or No.

Hope this helps.

Pete

Hi
Try this in C2 and down:
=IF(D2="YES","MODERATE","MILD")

Brilliant! thank you so much.

Glad to help.

I see that you have joined the forum today, so there are a couple of "admin" type tasks you should undertake to wrap things up on this thread:

If that takes care of your original question, please take a moment to select Thread Tools from the menu above and to the right of your first post in this thread, and mark the thread as SOLVED.

Also, since you are relatively new to the forum, you might like to know that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

Pete