Cheeky Little Two for......

[Sykovampyr]

Hi Guys,

I have two REALLY quick ones!

I need a formula beaded on a Percentage result in H3. If the percentage is below 50% I need a text result saying ACTION, If it is between 50% and 80% I need a Result Saying MOVE and 80%+ I need a Result saying GREAT, I have tried:

=IF(H3>79.999%,"GREAT"),IF(H3>49.99%,"ACTION"),IF(H3<50%>79.998%,"MOVE")

But just get VALUE as the result.........

Also is there a way to get A1 in a sheet to display the Tab Name?

Thanks a million!

 

[Cristy]

try like this
=IF(H3>79.999%,"GREAT",IF(H3>49.99%,"ACTION",IF(AND(H3>50%,H3<79.998%),"MOVE",0)))

 

[Sykovampyr]

try like this
=IF(H3>79.999%,"GREAT",IF(H3>49.99%,"ACTION",IF(AND(H3>50%,H3<79.998%),"MOVE",0)))

I have tried this but for 3% result I get a 0 value..... Any Ideas?

 

[FormR]

=if(h3>=80%,"great",if(h3<50%,"action","move"))

 

[VoG]

For Q2 try

=RIGHT(CELL("filename",A1),LEN(CELL("filename",A1))-FIND("]",CELL("filename",A1)))

 

[Sykovampyr]

=if(h3>=80%,"great",if(h3<50%,"action","move"))

Awesome, Thank you!!!

 

[Sykovampyr]

For Q2 try

=RIGHT(CELL("filename",A1),LEN(CELL("filename",A1))-FIND("]",CELL("filename",A1)))

PERFECT!!!!!! Thanks Guys!!

 

[Cristy]

=if(h3<50%,"action",if(and(h3>=50%,h3<80%),"move",if(h3>=80%,"great","false")))