Reference value within formula instead of other cell?

[SuperCoog]

I am attempting to make a formula that can give me my desired result with one cell being used.

I have written a nested IF(AND) statement that gives me the result I need, which is great, but I refer to a particular cell each time I write a line. For example, I have a formula within cell A1 which gives me a number. My IF(AND) statement has a series of ranges that gives me a desired result based on the value of A1. Currently A1 is being referenced 7 times within the IF statement.

My current solution works, but it requires me to have two cells used. One for the value, another for the IF statement.

I know the way to brute force this would be to copy the formula in cell A1 each time it is referenced in my IF statement, but I was wondering if there is a way to reference that value within the same cell in a cleaner way.

Thank you for any help in advance.

 

[jasonb75]

You can use the LET function for that if you have it, other than that you will have to use your existing methods. That said, a formula that repeats 7 times can usually be shortened somehow but without seeing both formulas in full there is not really much that I can suggest.

 

[SuperCoog]

Thanks for the suggestion. I'll give that a try.