If function equation

[completelogistics]

To all;

How many equations can I fit into an IF function?

This is what my equation looks like at present but it won't let me finalize it.

=IF(K6<=4,H6/0.65,IF(K6=5,H6/0.74),IF(K6=6,H6/.645)IF(K6=7,H6/.42)IF(K6=8,H6/.474))

I have 13 portions to put in.

Please help.

 

[dbn]

I'm not sure of the answer to your question - but it's a lot more than 13.

I think your syntax is a bit wrong - try the below:

=IF(K6<=4,H6/0.65,IF(K6=5,H6/0.74,IF(K6=6,H6/0.645,IF(K6=7,H6/0.42,IF(K6=8,H6/0.474)))))

 

[completelogistics]

THANKS dbn!!!!!

That is exactly what I needed. I cut and pasted your formula into my spreadsheet and voila! it works!!!!

Greatly appreciated!!!

 

[marka87uk]

Although you have it working now, the way I'd do it is to have a lookup table and use a VLOOKUP, then you can change the values if needed without changing the formulas.

=H6/VLOOKUP(K6,LookupTable,2,FALSE)

 

[T. Valko]

To all;

How many equations can I fit into an IF function?

This is what my equation looks like at present but it won't let me finalize it.

=IF(K6<=4,H6/0.65,IF(K6=5,H6/0.74),IF(K6=6,H6/.645)IF(K6=7,H6/.42)IF(K6=8,H6/.474))

I have 13 portions to put in.

Please help.

Create a 2 column table something like this:

Book1
	A	B
1	1	0.65
2	2	0.65
3	3	0.65
4	4	0.65
5	5	0.74
6	6	0.645
7	7	0.42
8	8	0.474
9	9	0.63
10	10	0.72
11	11	0.85
12	12	0.06
13	13	0.64
Sheet1

Then your formula would be:

=H6/LOOKUP(K6,A1:B13)