|When you post a question in a help forum, please try to use a subject line that gives the readers some idea about the question.|
If everyone used a generic subject line like "Excel Formula Needed" we wouldn't be able to tell one question from another and the archives would be impossible to search.
I have changed the subject line of this thread.
As for your question, you've told us what you want to happen if A27 is between those 2 numbers, but you haven't told us what you want to happen if A27 is not between those numbers.
This IF statement might get you started, since it addresses the question you asked, but the text indicates the part of the formula that needs to be changed if A27 doesn't meet your criteria.
=IF(AND(A27>60000, A27<72000), (A27-60000)*0.05, "Conditions For A27 Not Met")
Office Forum Moderator
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.