Formula needed!!

[Icehockey44]

Hi All,

I am after a formula to bring back the following:

If cell A = route and Cell B is less than 240 bring back Under, if cell B is over 240 bring back Over, or, if Cell A = Static and Cell B is less than 240 bring back Under, if cell B is over 240 bring back Over.

I know for someone out ther ethis is a really simple task, but I can only get 1 part of it!!

looking forward to your help

Donna

 

[Andrew Poulsom]

Like this?

=IF(OR(A1="route",A1="Static"),IF(B1<240,"Under","Over"),"")

 

[JackDanIce]

Hi,

Try:

=IF(OR(A1="Route",A1="Static"),If(B1<240,"Under",Over"),"A1 is not Route or Static")

 

[Icehockey44]

Thanks for this Andrew, it would of taken me ages to get to this conclusion. It has worked a treat.

many Thanks

Donna

 

[Icehockey44]

I now need to amend this formula!!!

If cell A = route and Cell B is less than 240 bring back Under, if cell B is over 240 bring back Over, or, if Cell A = Static and Cell B is less than 60 bring back Under, if cell B is over 60 bring back Over.

I have highlighted the amended part of the formula in RED. I guess now that the numbers involved have changed, so will the formula?!?

Looking forward to your help on this one

Cheers

Donna

 

[MMIILP]

If cell A = route and Cell B is less than 240 bring back Under, if cell B is over 240 bring back Over, or, if Cell A = Static and Cell B is less than 60 bring back Under, if cell B is over 60 bring back Over.

Hello Donna, this should work:

=if(and(a="route",b<240),"Under",if(and(a="route",b>240),"Over",if(and(a="static",b<60),"Under",if(and(a="static",b>60),"Over",""))))

No doubt there are people clever enough to shorten the sequence I've used, but this will work, if slightly inefficiently.

 

[Icehockey44]

MMIILP. thanks ever so much, this has also worked. it doesn't matter how long the formula is, just as long as it works I am more than happy.

Cheers for that

Donna