Hi all
What I need to be able to do is if 1 or 2 is in B6 then * 8% if 3 is in B6 then *9% if 4 is in B6 * 10% and if 5 is in B6 * 11% if 6 is in B6 * by 12%. all has to be in one cell
If someone can help me out with this that would be great
Thanks
Ryan
What I need to be able to do is if 1 or 2 is in B6 then * 8% if 3 is in B6 then *9% if 4 is in B6 * 10% and if 5 is in B6 * 11% if 6 is in B6 * by 12%. all has to be in one cell
If someone can help me out with this that would be great
Thanks
Ryan