Excel Formula?

Question

I need help with writing a formula. I need to have formula that is generated from a set of 7 results. the resukts show if something has improved or gotten worse.

if 0-2, improve, then have to sell
if 2-5 improve then have to hold
if 5-7 improve then have to buy

I have tried: =if("Improved"<2,"SELL",IF("Improved"<5,"HOLD","BUY"))
but it only works for 2 of the options and seems to always miss out one of the actions.

can anybody help with the actual formula, ive tried using the formula wizard on excel but no joy...thanks

Answer 1

If you have a lot of cells to calculate you may want to ensure your code is as tight as possible. By default you are assuming that if the answer is above 5 then it should read "Buy". Your formula should also cater for cells that have no value otherwise you will get "Sell" as your result. To do this your formula should read:

=IF(ISBLANK(A1), "" , IF(A1<=2,"Sell", IF(A1<=5,"Hold" , "Buy")))
I've spaced it to make it easier to read so when you type it in don't include any spaces.
The last IF statement caters for any answer greater than 5 and the ISBLANK ensures the cell is populated.

I have used <=2 and <=5 in the formula but your calculations specify 0-2 then 2-5 and 5-7. This would cause an overlap so you may want to change this to 0-2 then 3-5 and 6-7.

Finally if you want a visually aid to the calculation highlight all the cells with the answer and click on "format" on the menu the "Conditional Formatting" - You can only add 3 conditions which is all you need for this.
In Condition 1 change the 1st drop down list to read "Cell Value Is"
The 2nd drop down to read "between" and in the last 2 cells type 0 and 2 respectively. Now click on "Format" and alter the patterns to red.
To add a condition use the "Add >>" button and do as above but use 3 and 5 as your numbers and the patterns set to yellow and for Condition 3 use 6 and 7 and green pattern.

Ok so this works for the numbers but the words are slightly different.
Go to the cells with the words Sell/Buy and Hold, highlight them all and in Conditional Formatting:
Cell Value is..........equal to........="Sell"
Set the pattern to match the one you used for the numeric answers. Repeat the steps for Hold and Buy using the same colours.
Its important you type the wording as:
="Sell".................with sign and brackets or just type the word:
Sell......................and nothing else
otherwise it wont work

Hope that helps

Answer 2

1

Answer 3

Let's say you have your data in Sheet1, here's how to solve this problem -

1. Create a reference table on a separate sheet (let's say "Sheet2") as follows -

A column list the numbers - 0, 1, 2, 3...7
B column list the actions for each number - sell, sell, hold, hold, hold, buy, buy, buy

2. Go back to your original data sheet next to the number column enter the following formula -

=VLOOKUP(A1,Sheet2!A:B,2,0)

This is assuming the number is in the A column, if your number is in F column, then change A1 to F1, then copy this formula all the way down - now you should see the corresponding actions for each line

Answer 4

If you want tho modify your lifetime then that is your guide https://tr.im/u6jwj , Manifestation Miracle.
With Manifestacion Miracle you will learn what the law states of attraction. The Manifestation Miracle does a good job of teaching you merely how firmly you'll need to want anything to be able to do what' required to be able to get it. Think of need the same way you'd think of a candle. If the candle is using powerful then you'll push previous limitations to be able to get that which you want. If the candle is not burning at all, then you definitely won't. Desire is just a using fireplace. Not just have you got to have it, but also you have to help keep throwing timber about it to help keep it burning.
That guide can be as straightforward because it gets and with it you'll manage to begin thinking in what' possible really fast.

Answer 5

Seems to me a vlookup will do it for you if you actually have more than 3 levels. Here's my article:
http://www.officearticles.com/excel/vlookup_formulas_in_microsoft_excel.htm

If you only have the 3 levels you mentions, then this should do it:
=IF(A1<=2,"sell",IF(A1<=5, "hold",IF(A1<=7,"improve")))

A1 is where the value resides.

Answer 6

Do you want to know one of the factors typical Law of attractionproduct does not work for so many individuals?Believe of it like a diet. If you wish to slim down and you work hard to lose it

Answer 7

Mel...it's an unusual formula. I can't answer it but try here.
http://mistupid.com/tutorials/excel/index.htm
http://www.bcschools.net/staff/ExcelHelp.htm
http://www.worldstart.com/tips/cat-topics.php/17

hope this helps

Answer 8

http://www.techtutorials.net/