Need Formula For Less Than / Greater Than

November 26, 2018 at 23:26:23
Specs: Windows 7
Hi!

I seek your kind cooperation to represent it in formulae

If Col A is greater than 0 but less than 10000 the output will be 0, if Col A is greater than 10000 but less than 15001 the output will be 110 if Col A is greater than 15000 but less than 25000 the output will be 125.
This relation is required in a cell


Col A Col B Output
0 10000 0
10001 15000 110
15001 25000 120

Thank you


See More: Need Formula For Less Than / Greater Than

Reply ↓  Report •

#1
November 27, 2018 at 05:45:10
I'm a little confused by your requirements.

1 - Why are you showing us Column B in your example? There is no mention of Column B in the requirements portion your post.

2 - You said:"If Col A is greater than 0 but less than 10000 the output will be 0, if Col A is greater than 10000 but less than 15001 the output will be 110"

What should the output be if Col A equals 0 or equals 10000? Your example data shows a 0 in Column A and a 0 as the output, but that is not what your requirements state.

3 - You said: "if Col A is greater than 15000 but less than 25000 the output will be 125."

The last row of your example data shows 120 for that situation. Why is that?

4 - I have 2 posting tips to offer:

First, when posting in a Help forum such as this, please try to use a Subject Line that tells us something about your question. If everyone used a generic Subject Line such as "Formula Needed" we wouldn't be able to tell one question from another and the Archives would essentially be useless.

I have edited the subject line of your post to show you what I mean. Scan the list of questions in this forum to see the types of Subject Lines that others have used.

Second, if you click on the How-To link at the bottom of this post, you can read the instructions on how to post data in this forum so that the column line up is retained.

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


Reply ↓  Report •
Related Solutions


Ask Question