Greater Than/Less Than Formula needed

June 28, 2011 at 04:21:31
Specs: Windows XP
I am trying to create a formula to show...

If the number in A27 is greater than 60000 but less than 72000 then A27-60000 will be paid at 5%


See More: Greater Than/Less Than Formula needed

Report •

#1
June 28, 2011 at 06:38:36
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")

DerbyDad03
Office Forum Moderator

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
June 28, 2011 at 07:27:53
Apologies for that and thanks for your help.

If A27 is below 60000 the box should say 0 and if it is above 72000 the box should say 600

Thanks


Report •

#3
June 28, 2011 at 07:54:16
Here you go, as long as you never expect A27 to be exactly 60000 or exactly 72000. You didn't mention that in your requirements, so you might not be happy with the results.


=IF(A27<60000,0,IF(AND(A27>60000, A27<72000), (A27-60000)*0.05, 600))

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question