Formula to give yes or no result based on cells data

**twiztid** · 01-04-2014, 09:35 AM

Hi guys,

I am currently working on some stats for a fantasy sport game, I play with some mates and need to work out how to output a yes or no for a conditional result.

Basically, my form looks like this.

N3	O3	P3	Q3
5	16	143	Formula to go here

So, basically what I am trying to work out is. I need the Q3 to first work out if the P3 =>150 (equal or larger than 150) it will result "YES". Which it can stop and not check the 2nd condition. If it is a no, it will then go to check the second condition. Which is checking if the N3+O3 => 40 (equal or larger than 40) it will also result with "Yes". Otherwise it will just result "No".

I have been trying my best to work out the formula myself but am getting more and more confused and running out of days before the season starts.

If anyone is able to help that would be great.

Cheers,
Twiztid

**rcm** · 01-04-2014, 09:45 AM

This is the formula that goes in Q3

Please Login or Register  to view this content.

**bebo021999** · 01-04-2014, 09:46 AM

Try:
=IF(OR(P3>=150,N3+O3>=40),"Yes","No")

**twiztid** · 01-04-2014, 09:47 AM

Wow, super fast response. It was a lot less complex than I was making it. Hahaha.

Thanks very much for your responses and it worked great.

**arlu1201** · 01-06-2014, 05:33 AM

Based on your last post in this thread, its apparent that you are satisfied with the solution(s) you've received and have solved your question, but you haven't marked your thread as "SOLVED". I will do it for you this time.

In future, to mark your thread as Solved, you can do the following -
Select Thread Tools-> Mark thread as Solved.

Incase your issue is not solved, you can undo it as follows -
Select Thread Tools-> Mark thread as Unsolved.

Also, since you are relatively new to the forum, i would like to inform you that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post which helped you. This adds to the reputation of the person who has taken the time to help you.

Formula to give yes or no result based on cells data

LinkBack

Thread Tools

Rate This Thread

Display

Formula to give yes or no result based on cells data

Re: Formula to give yes or no result based on cells data

Re: Formula to give yes or no result based on cells data

Re: Formula to give yes or no result based on cells data

Re: Formula to give yes or no result based on cells data

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] using a max formula on a column with no data to give a Blank result

VLOOKUP That needs to give result based on a ranking list

Row-based conditional search to give a cumulative result

[SOLVED] Provide a match from 2 cells to give a result from another

How do I get a cell to give a result based on the month we are in?

Bookmarks

Bookmarks

Posting Permissions