Forum Discussion
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?
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.
7 Replies
- 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
This formula must be insert in column I: IF(D2<=15000;''poor'';D2).
That's the answer of the question.
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.
=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?
