Google Sheets Help!

skaif · 2 Sep 2015 at 08:15

Quick one here!
https://docs.google.com/spreadsheets/d/1kJI0TwIIbEVXBmvPx2WytDdqPu-ECgbeRovjAIcqvds/edit?usp=sharing

I am trying to get this sheet to take values from the K and Q column to represent an outcome in the R column.
So for example, if the target (Column K) is 'E'. I want it to use the formula

Code:

=IF(Q4>=3,"Rapid",IF(Q4>=2.8,"Good","Slow"))

But if the target is 'S' I want it to use the formula

Code:

=IF(Q4>=2.8,"Rapid",IF(Q4>=2.6,"Good","Slow"))

and so on.

Can this be done?

Cheers

dirtychinchilla · 2 Sep 2015 at 08:32

Combine the formulae with an OR? So, something like:

Code:

=OR(IF(Q4>=3,"Rapid",IF(Q4>=2.8,"Good","Slow")),IF(Q4>=2.8,"Rapid",IF(Q4>=2.6,"Good","Slow")))

Might work??

skaif · 2 Sep 2015 at 11:14

Thanks for the input but it needs to take the value in the target column (K) in order to get the correct output.
Hope that makes sense!

DaleTheWhale · 2 Sep 2015 at 11:50

ELSEIF can do this?

skaif · 2 Sep 2015 at 12:23

Could you please elaborate?

I basically want this:
If value in column K is E
Then the formula in column R should show
=IF(Q4>=3,"Rapid",IF(Q4>=2.8,"Good","Slow"))
But if the value in column K is S it should show
=IF(Q4>=2.8,"Rapid",IF(Q4>=2.6,"Good","Slow"))
and so on...
How would I get an ElseIF to do that?

skaif · 2 Sep 2015 at 12:41

Ok I think I have done it using a bunch of IF statements!
This seems to work, if anyone has a more efficient way please let me know!

Code:

=IF(K4="E",IF(Q4>=3,"Rapid",IF(Q4>=2.8,"Good","Slow")),IF(K4="S",IF(Q4>=2.8,"Rapid",IF(Q4>=2.6,"Good","Slow")),IF(K4="CT",IF(Q4>=2.6,"Rapid",IF(Q4>=2.4,"Good","Slow")),IF(K4="WT",IF(Q4>=2.2,"Rapid",IF(Q4>=2,"Good","Slow"))))))

dirtychinchilla · 2 Sep 2015 at 12:43

There is no such thing as ELSEIF in Excel, it's If(y,n,else), so what you've come up with makes sense.

Sorry I couldn't quite understand what you were after before.

DaleTheWhale · 2 Sep 2015 at 12:58

dirtychinchilla said:
There is no such thing as ELSEIF in Excel, it's If(y,n,else), so what you've come up with makes sense.

Sorry I couldn't quite understand what you were after before.

Indeed,

Sorry I was dragged away before I could explain myself!
You can nest up to (I think 7-8) IF statements which you can use to create ELSEIF logic.

What you've put together is essentially that.

dirtychinchilla · 2 Sep 2015 at 13:07

You can do more than that I think. I'm sure I've had some nuts formulae with 10+ IFs

skaif · 2 Sep 2015 at 18:47

Cool thanks for the input gents