IF formula with a condition

[kenny scott]

Hi guys

ive attached a very simple spreadsheet for some help

I have two cells that produce "at Risk" or "no risk" and I have a outcome at the bottom

the rule is simple if either show "at risk" then the cell will show as "at risk" if both show as "no Risk" then the outcome will show as no risk

but for the life of me I cant workout how to do it

[Pepe Le Mokko]

Assuming no empty cells =if(AND(A1="No Risk", a2="No Risk"),"No Risk","at risk")

[kenny scott]

Thank you so much!

[Pepe Le Mokko]

You're welcome

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.

Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

[Glenn Kennedy]

Hi. Forum Rule 1 is very short. It states: "Title must briefly summarize your request."

A GOOD thread title is the sort of thing you would use as a search term on Google*. Your chosen title would produce a squillion useless hits. In future, please take a bit more time to think of a descriptive title that would be "Google-friendly". Many people search the forum answers looking for help and your very general title wouldn't help them at all.

Since you are a new user of this site. On this occasion, I have changed it for you.

However, if you continue to use weak titles, you can expect to have your thread BLOCKED until you change it yourself. If that happens, to edit the thread title, open the original post, click "Edit Post" (bottom right) to access the area where you can edit your title.

*Other search engines are available!!!

Regards,

Glenn.

[kenny scott]

Sorry Glenn

[Glenn Kennedy]

No worries!!