#### moe10134

##### Board Regular

- Joined
- Sep 8, 2005

- Messages
- 157

Question:Can you apply AND & OR statements to an IF statement?

I am looking for a formula that will give me multiple answers. I am looking for the result of a SUM. IF the sum is less than 9, enter SUM. If the SUM = 10, replace that with a 1. If the total is 11 or 22, give me 11 or 22. I need a find a formula that allows me a SUM of:

1: SUM of cells if less than 9 = SUM.

2: IF SUM = 10, result = 1 - possible REPLACE?

3: IF SUM = 11, result =11

4: IF SUM = 22, result = 22

I have tried numerous, IF statements with AND & OR and REPLACE & TRUE, FALSE statements, I just need to have a result of "SUM","1", "11",or "22' in an absolute cell. Could I use a possible HLOOKUP/VLOOKUP/INDEX formula for results? I have named cells as absolute and tried to figure it out that way and I still can't get the final result of :"SUM = (1-9)"; "1" if 10; and "11" or "22". Possibly looking for a multiple TRUE result.

i hope this makes sense. Please let me know if you need more clarification.

Thanks much!