• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to get two different names with same value

SUDARSAN

Member
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
 

Attachments

  • Major_All.xlsx
    10.4 KB · Views: 11
I don't understand.
Formula is fine.
If value = 1000 you get Major
If value<> 1000 you get All
 

Attachments

  • Major_All.xlsx
    10.4 KB · Views: 4
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"

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
 
SUDARSAN
You should reread Forum Rules - those are for You too
There are few lines about cross-posting, which You have missed.
 
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.
 
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
 
Back
Top