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: 1482) 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