Forum Discussion
chadiexcel
Nov 03, 2020Copper 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 som...
- Nov 03, 2020
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.
NikolinoDE
Nov 03, 2020Platinum Contributor
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
- chadiexcelNov 03, 2020Copper Contributor
This formula must be insert in column I: IF(D2<=15000;''poor'';D2).
That's the answer of the question.
- NikolinoDENov 03, 2020Platinum Contributor
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.
- chadiexcelNov 03, 2020Copper Contributorthankyouu very much!!!!!!