Simple Formula IF

[mojo300]

Why is this not working for me?

Excel Workbook
	L	M
1	37	FALSE
2	10	FALSE
3	1	FALSE
4	15	FALSE
5	3	FALSE
6	7	FALSE
7	2	FALSE
8	2	FALSE
9	5	FALSE
10	9	FALSE
11	7	FALSE
Units Per Site

 

[Joe4]

Are you values in L1 formatted as Text or Numbers?
If Numbers, you don't use Text Qualifiers in your formula, i.e. use:

=IF(L1=1,...

instead of

=IF(L1="1",...

and update for all instances where you are checking the value in column L.

 

[steve the fish]

Remove the quotes around the 1,2,3. You also have no false statement for 3rd IF.

 

[mojo300]

Remove the quotes around the 1,2,3. You also have no false statement for 3rd IF.

Thank You to all