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%

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

notbetween 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.

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

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.

Ask Your Question

Weekly Poll

Have you played Jackbox during the pandemic?

Discuss in The Lounge

Poll History