Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Logic based Formula Required

0

Hi All,

Good day!

I need one help from u guyz.

Pls help me with the formula in excel for the below problem

"If the cell is greater than 30000 and lesser that 43000, then it should display 1250 else zero and if the cell is greater that 43001 and lesser than 50000, then it should display 2000 else zero and if it is above 50001 it should display 3000 else zero"

Thanks in advance

Post Edited
Title: Title was not descriptive.
Answer
Discuss

Answers

1

This formula should do the job.

=INDEX({0,1250,2000,3000},MATCH($A10, {0,30001,43001,50001}, 1))

The number to be evaluated in in cell A10. You can change that, of course. The result will appear in the cell where the formula resides. Any cell will do.

Discuss

Discussion

Elegant solution!
don (rep: 1989) Apr 27, '17 at 5:19 am
Add to Discussion
0

IF(AND(value>=30000,value<=43000),"1250",IF(AND(value>43001,value<=50000),"2000",IF(value>50000,"3000",0)))

please try this formula

Discuss


Answer the Question

You must create an account to use the forum. Create an Account or Login