Having trouble building a probability code within a Cell.

**kardoid** · 12-28-2011, 02:04 AM

Does anyone know how to properly write this formula to insert in a Excel Cell. "if [E1 is between 0 to 299 multiply by .15, if E1 is between 300 to 499 multiply by .26, if E1 is over 500 multiply by .33]+D1" I want to know if its possible to do it that complicated in just one cell. I am able to do the basic, for say anything i put in E1 i can multiply by x then add by D1. But I need to work with probability then the answer I get just add by D1. I just don't know If Excel can work with such a complicated formula.

Thanks for reading and hope you can help.

Thanks!

**shg** · 12-28-2011, 02:10 AM

Welcome to the forum, kardoid.

Please take a few minutes to read the forum rules, and then amend your thread title accordingly.

Thanks.

**kardoid** · 12-29-2011, 01:54 AM

Thanks for the advice. Read the rules and renamed the post.

**Haseeb Avarakkan** · 12-29-2011, 02:54 AM

Hello kardoid,

use LOOKUP function, like,

=E1*LOOKUP(E1,{0,300,500;1.15,1.26,1.33})+D1

**kardoid** · 12-29-2011, 01:58 PM

Thanks Haseeb! it worked great! The only thing I had to do at the end of the formula was =E1*LOOKUP(E1,{0,300,500;1.15,1.26,1.33})-E1+D1, because it was adding the percentage to the original number. But after that it came out fine. Thanks once again!

**Haseeb Avarakkan** · 12-29-2011, 03:22 PM

Originally Posted by kardoid

...it was adding the percentage to the original number...

That because, I thought you need E1+E1%+D1, if you only multiply it's % then +D1, just change the 1.15,1.26,1.33 to 0.15,0.26,0.33. like,

=E1*LOOKUP(E1,{0,300,500;0.15,0.26,0.33})+D1

If you are satisfied in the solution(s) provided, pleas mark your thread as SOLVED.

To mark your thread solved do the following:
- Go to the first post
- Click edit
- Click Advance
- Just below the word "Title:" you will see a dropdown with the word No prefix.
- Change to Solve
- Click Save

**kardoid** · 12-29-2011, 04:06 PM

That is great! it works even better! because I was adding another part to the formula but since it had that -E1 it wasn't letting me. But now its all resolved. Thanks a million!!