Fornula for displaying positive or negative variance

[Ivor]

Hello all again

Happy Monday to you.

Apologies as this question is very similar to my last, but need some urgent help.

I need a formula that will display a 'yes' or 'no' if the following condition is met:

If the value of cell (L17) is greater than 10% positive variance, then 'YES' else 'NO'.

Currently the value of L17 is 14%, therefore should be a 'YES', however how can I get the following to work:

IF(AND(L17=<0,"NO",L17>10%,"YES")) I apologise as I know there are too many arguements here but is there a way around this?

Thanjks Guys

Ivor

[NBVC]

Do you mean?

=IF(L17>10%,"Yes","No")

[Ivor]

Hello sir

Thank you for replying. I had that arguement in the first place but I got confused, because my boss started babbling about displaying positive variance. His arguement went like this:

IF(14%) = < 0, "NO", IF(14%) > 10% +,"YES".

The '+' sign in the equation is him depicting that he wants to identify a positive variance! BUT surely what you have provided is the same thing right? His way has too many arguements I think?

Thanks
Ivor

[royUK]

Use Conditional Formatting - Red for Negative variance, Blue for Positive

[NBVC]

What about between 0 and 14%, what should be displayed...

if you want a blank... then


=IF(L17< 0, "NO",IF(L17>10%,"YES",""))

[Ivor]

Thanks Roy Sir, that is what I will suggest to him if he doesn't like my suggestion.

Thanks again

[Ivor]

Hello

yes you are right. So unless he wants a blank within his sheet I should stick with the simplest formula that you gave, as it displays everything over 10% as a yes and anything under as a no. I can use conditional formatting on the source data to show 'red' for negative and 'blue' for positive.

Thanks again sir

Ivor

[royUK]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

[Ivor]

Thanks sir....done