If Statement problem

**Andrias14** · 12-01-2015, 10:23 AM

Hi there guys
I've been struggling with this problem for a good hour.

I have a 2 inputs for the function but 4 possible outputs they being :

Low High = Puzzle
Low Low = Dog
High Low = Plough Horse
High High = Star

Is there a possible formula that can sort that out for me.

Kind Regards

**Tony Valko** · 12-01-2015, 10:26 AM

Are High and Low the only possible entries? Might there be empty cells?

**Andrias14** · 12-01-2015, 10:30 AM

Wait i missed some essential details sorry.

like alot :/

Popularity Profitablity
Low Low = Dog
High High = Star
High Low = Plough Horse
Low High = Puzzle

Those are the only possible scenarios how this clears it up a bit

**Tony Valko** · 12-01-2015, 10:39 AM

Try this...

=IF(COUNTA(A1:B1)<2,"",IF(A1="Low",IF(B1="Low","Dog","Puzzle"),IF(B1="High","Star","Plough Horse")))

**Andrias14** · 12-01-2015, 10:48 AM

To Tony

Tony that worked a charm thank you very much i really appreciate it you have saved a lot of hassle, and i really admire what you're able to do

**Tony Valko** · 12-01-2015, 11:06 AM

You're welcome. Thanks for the feedback!

If Statement problem

LinkBack

Thread Tools

Rate This Thread

Display

If Statement problem

Re: If Statement problem

Re: If Statement problem

Re: If Statement problem

Re: If Statement problem

Re: If Statement problem

Thread Information

Users Browsing this Thread

Similar Threads

Problem with IF Statement

IF statement problem

Now() statement within a IF(AND statement problem

Problem with IF statement within a COUNTIF statement

SQL statement problem

problem with IF statement

If Statement Problem

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions