0
I need a if statement in excel with several conditions if A2 is greater than 120000 then put a 1 if A2 is greater than 200000 then put a 2 if A2 is greater that 300000 then put a 4 if not return a 0?
Updated: 8/20/2019
Sistakk
Lvl 1
∙ 12y agoBest Answer
I tried to use this but it is not working...
=IF(A7>=125000,"1",IF(A7>=200000,"2",IF(A7>=300000,"4","0")))
Wiki User
∙ 12y agoThis answer is:
Add your answer:
Earn +20 ptsQ: I need a if statement in excel with several conditions if A2 is greater than 120000 then put a 1 if A2 is greater than 200000 then put a 2 if A2 is greater that 300000 then put a 4 if not return a 0?
Write your answer...
Submit
Still have questions?
Related questions
Is 120000 equal to 1200?
No because it is 100 times greater than 1200
Round 124531 to the nearest 10000?
It is 120000.
What is 3 percent of 120000 pounds?
3% of 120000 = 3% * 120000 = 0.03 * 120000 = 3600
What is 20 percent of 120000 dollars?
20% of $120000 = 20% x $120000 = 0.20 x $120000 = 2400
120000 as an integer value?
It is 120000, exactly as it appears in the question!
What is the numeric value 120000?
120000
What is the journal entries under the periodic and perpetual systems of Beginning inventory 120000?
DR CR Inventory 120000 Capital 120000 DR CR Inventory 120000 Capital 120000
What is 70 percent of 120000?
70% of 120,000= 70% * 120000= 0.7 * 120000= 84,000
What is two percent of 120000?
2% of 120,000 = 2% * 120000 = 0.02 * 120000 = 2,400
What is one percent of 120000?
1% of 120,000= 1% * 120000= 0.01 * 120000= 1,200
How do you write 120000 in numerical value?
120000
Which is greater 120 tons or 120000 pounds?
120 tons.120 tons.120 tons.120 tons.
Copyright ©2024 Infospace Holdings LLC, A System1 Company. All Rights Reserved. The material on this site can not be reproduced, distributed, transmitted, cached or otherwise used, except with prior written permission of Answers.