# 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 formulaeIf 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 cellCol A Col B Output0 10000 010001 15000 11015001 25000 120Thank you

See More: Need Formula For Less Than / Greater Than

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

Reply ↓  Report •
Related Solutions