Nov 03 2020 09:02 AM
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?
Nov 03 2020 10:14 AM
=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.
Nov 03 2020 10:20 AM
Nov 03 2020 10:23 AM
Nov 03 2020 10:29 AM
This formula must be insert in column I: IF(D2<=15000;''poor'';D2).
That's the answer of the question.
Nov 03 2020 10:47 AM
Solution
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.
Nov 03 2020 11:07 AM
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)
Nov 03 2020 10:47 AM
Solution
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.