SOLVED

formula Help

Copper Contributor

Exercise 11: Add a column in which the word “poor” is shown in rows where the income/person is less
than or equal to 15000, and where the value itself is shown if this is not the case.

 

Could someone tell me why it does not accept the ''poor'' part?

 

afbeelding_2020-11-03_180101.png

7 Replies

@chadiexcel 

 

=IF(B2<=15000;"poor";"")

 

should work without problems, has been tested.

 

I would be happy to know if I could help.

 

Nikolino

I know I don't know anything (Socrates)

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.

Hi Nikolino,
It still doesn't work :(
Maybe there is something wrong with the settings, maybe you know something about that?
Is it possible to insert the file (without sensitive data, please), so I can see whether it could be on the worksheet. thx in advance

@NikolinoDE 

This formula must be insert in column I:  IF(D2<=15000;''poor'';D2).

That's the answer of the question.

best response confirmed by chadiexcel (Copper Contributor)
Solution

@chadiexcel 

 

It works !

safe and tested :)

File inserted

 

 

Wish you a nice day / night with lots of health, joy and love.

 

Nikolino

I know I don't know anything (Socrates)

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.

thankyouu very much!!!!!!

@chadiexcel 

you are welcome

I wish you continued success with Excel.

And…please keep asking here - I just taught myself Excel with the help of this forum… nearly :)

 

Nikolino

I know I don't know anything (Socrates)

 

1 best response

Accepted Solutions
best response confirmed by chadiexcel (Copper Contributor)
Solution

@chadiexcel 

 

It works !

safe and tested :)

File inserted

 

 

Wish you a nice day / night with lots of health, joy and love.

 

Nikolino

I know I don't know anything (Socrates)

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.

View solution in original post