Formula help

[uul]

Morning everyone -

I have this formula

=VLOOKUP($S$739,A:L,10,FALSE)&" passes have taken place on the football.com website and is "&TEXT(ABS($AF$737)," #%")&" lower than the previous week"

The issue is $AF$737 can be a negative or positive % i.e -10% or 10%, so what i need to happen is the lower than the previous week text - word lower change from higher or lower based on positive or negative number in $AF$737

Thanks for looking

uul

 

[Khalid NGO]

Hi uul,

Try this working or not for you.
=VLOOKUP($S$739,A:L,10,FALSE)&" passes have taken place on the football.com website and is "&TEXT(ABS($AF$737)," #%")&IF($AF$737=>0,"Higher ","Lower ")&"than the previous week"

otherwise upload a sample.

 

[Bhawani]

please try below function
=VLOOKUP($S$739,A:L,10,FALSE)&" passes have taken place on the football.com website and is "&TEXT(ABS($AF$737)," #%")&" "&IF(AND(AF737<10%,AF737>0%),"Higher Change",IF(AND(AF737<0%,AF737>-10%),"Lower Change",""))

function which is used is

=IF(AND(AF737<10%,AF737>0%),"Higher Change",IF(AND(AF737<0%,AF737>-10%),"Lower Change",""))

and it would be better if you post a sample file.

 

[uul]

Great stuff thanks both, all working nicely now.

 

[Khalid NGO]

Welcome...
Thanks for the feedback @uul