Excel Formula Help

  • Thread starter Thread starter SB
  • Start date Start date
S

SB

Is there a way to create a formula that evenly divides a number by the
numbers 2 and 3?

For example. I want to know how many times the number 2 and the
number 3 go into the number 13. The answer should be 2=2 and 3=3.

Another example would be how many times the number 2 and the
number 3 go into the number 19. Again the answer should be 2=2 and
3=5.

Here's the tricky part, if the number to be divided is 4, then the answer
should be 2=2 and 3=0. If the number to be divided is 6, then the
answer should be 2=0 and 3 = 2.

I would like the number 3 to take president over the number 2 as long
as the final outcome equals a complete solution.

thank you for you help.
 
SB said:
Is there a way to create a formula that evenly divides a number by the
numbers 2 and 3?

For example. I want to know how many times the number 2 and the
number 3 go into the number 13. The answer should be 2=2 and 3=3. ....
I would like the number 3 to take president over the number 2 as long
as the final outcome equals a complete solution.
Click to expand...

First, don't post in MIME/HTML. Post in plain text.

=IF(OR(X<0,X=1),"You're on your own.",CHOOSE(1+MOD(X,3),
"2=0 & 3="&(X/3),"2=2 & 3="&((X-4)/3),"2=1 & 3="&((X-2)/3)))
 
Back
Top