SOLVED

New Contributor

# formula Help

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?

7 Replies

# Betreff: formula Help

=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.

# Betreff: formula Help

Hi Nikolino,
It still doesn't work
Maybe there is something wrong with the settings, maybe you know something about that?

# RE: formula Help

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

# RE: formula Help

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 (New Contributor)
Solution

# RE: formula Help

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.

# RE: formula Help

thankyouu very much!!!!!!

# RE: formula Help

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)