Need help with below formula

[CAPozzo0915]

=IF(E16=1,H16/1), IF(E16=12,H16/12), IF(E16=4,H16/4,)))

The above formula is not working, can someone tell me what is off???

 

[Marcelo Branco]

Try something like,

=IF(E16=1,H16/1,IF(E16=12,H16/12,IF(E16=4,H16/4,"Undefined")))

M.

 

[gnrboyd]

Try this.... (Remove a couple of the end parentheses)

=IF(E16=1,H16/1,IF(E16=12,H16/12,IF(E16=4,H16/4,)))

That would fix the formula error but I don't see that formula doing anything more than =H16/E16 assuming that E16 can only equal 1,12, or 4.

 

[CAPozzo0915]

Thanks but so far neither of these solutions are working....

 

[Marcelo Branco]

Thanks but so far neither of these solutions are working....

Are you getting an error or a wrong result?

M

 

[CAPozzo0915]

wrong result. If the cell equals 4 then I should be getting a quarterly result however i am getting a monthly result...

 

[gnrboyd]

The formula seems to be working fine for me. Perhaps you can post your example using one of the programs that convert Excel into html. (See sticky posts in the Excel Questions section.) That might help someone see the problem.

As I stated before, there really isn't a reason to have this formula with all of the if/thens when all you need is a simple division formula. As you can see, the second set of examples gives the same result with the exception that the first set is limited to 1,4, or 12 as a divisor.

Book1
	A	B	C	D	E	F	G	H
16	100				1			100
17	25				4			100
18	8.3333333				12			100
19	Undefined				10			100
20
21	100				1			100
22	25				4			100
23	8.3333333				12			100
24	10				10			100
Sheet1

 

[CAPozzo0915]

so what i notice is when I take one cell with the correct formula and copy over it is copy progressively instead of pulling the same cells from the original formula? How do I stop it from copying over progressively?