Formula Help 1

[arvarr]

Hi
Needing help with a formula.
Table worksheet is the combination of requirements.

Need a formula in the Data worksheet to return the outcome.
Sample file attached.

Thanks,
Arv

 

[SkipVought]

here's the modification. if you look at the VBA, you'll see that I check that Amount is between -100 and 100 and got a handfull of Outcome 30.

However, now you have undefined Status values that don't resolve to any outcome. Good luck!

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]
"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein

 

[arvarr]

Yay...Thanks for updating the code . Gives me the outcome that i want.
Regards,
arv

 

[arvarr]