How to get two different names with same value

[SUDARSAN]

Dear Forum Friends,

I tried = IF ( A1=1000,"Major", "All")

it returning only "Major"

but I need to get "Major" in first row and "All" in next row

if value is < 1000 it should give only "All"

please Help

Thank you in advance
Regards
SUDARSAN

 

[Belleke]

I don't understand.
Formula is fine.
If value = 1000 you get Major
If value<> 1000 you get All

 

[pecoflyer]

Cross post https://www.mrexcel.com/board/threa...in-2nd-row-if-x-it-should-return-all.1168370/

 

[SUDARSAN]

I don't understand.
Formula is fine.
If value = 1000 you get Major
If value<> 1000 you get All

THANK YOU FOR YOUR VALUABLE TIME

IF VALUE IS 1000 IT SHOULD RETURN
IN FIRST CELL "MAJOR"
SECOND ROW(CELL) "ALL"

IF VALUE IS 999 IT SHOULD RETURN ONLY "ALL"

Cross post https://www.mrexcel.com/board/threa...in-2nd-row-if-x-it-should-return-all.1168370/

Thanks for you for concentration on my posts

dear I am beginner in excel that too started excel work to help some formers , I need a solution and help , so I am trying many ways ,

I working for a poor formers, to teach them to spend less and increase the yield

formers feeding the world I am trying my part to help them, so that we all have good food every day 3 times

I don't know what is your problem

If you would like to help please support , else please avoid

kindly do not target me ,

targeting the people is your job, then kindly delete my name from your list

this is my last reply

Thank you

with best regards
SUDARSAN

 

[vletm]

SUDARSAN
You should reread Forum Rules - those are for You too

Site Rules - New Users - Please Read

Hi all, Welcome to the Chandoo.org Forums. Posting Rules & Etiquette The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge. The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in...

chandoo.org

There are few lines about cross-posting, which You have missed.

 

[Peter Bartholomew]

I don't know what is your problem. If you would like to help please support, else please avoid.
Kindly do not target me ,

Do not take offence. Like other forums, this site has rules to make the exchange productive and cross-posting is an important issue that needs to be managed. You have not been singled out for unfair treatment or victimised. The moderators are simply performing their task.

Returning, to your question
= IF(value>=1000, {"major";"all"},"all")
should work with Excel 365 and a slightly different approach would be needed for older versions.

 

[SUDARSAN]

Do not take offence. Like other forums, this site has rules to make the exchange productive and cross-posting is an important issue that needs to be managed. You have not been singled out for unfair treatment or victimised. The moderators are simply performing their task.

Returning, to your question
= IF(value>=1000, {"major";"all"},"all")
should work with Excel 365 and a slightly different approach would be needed for older versions.

THANK YOU Mr. PETER

agreed

Thank you , Thank you very much
I will try it