SOLVED

formula Help

%3CLINGO-SUB%20id%3D%22lingo-sub-1850075%22%20slang%3D%22en-US%22%3Eformula%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1850075%22%20slang%3D%22en-US%22%3E%3CP%3EExercise%2011%3A%20Add%20a%20column%20in%20which%20the%20word%20%E2%80%9Cpoor%E2%80%9D%20is%20shown%20in%20rows%20where%20the%20income%2Fperson%20is%20less%3CBR%20%2F%3Ethan%20or%20equal%20to%2015000%2C%20and%20where%20the%20value%20itself%20is%20shown%20if%20this%20is%20not%20the%20case.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECould%20someone%20tell%20me%20why%20it%20does%20not%20accept%20the%20''poor''%20part%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22afbeelding_2020-11-03_180101.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F231209i8F96E6610BB9FF0B%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22afbeelding_2020-11-03_180101.png%22%20alt%3D%22afbeelding_2020-11-03_180101.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1850075%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1850372%22%20slang%3D%22de-DE%22%3ESubject%3A%20formula%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1850372%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F856253%22%20target%3D%22_blank%22%3E%40chadiexcel%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DIF(B2%26lt%3B%3D15000%3B%22poor%22%3B%22%22)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3Eshould%20work%20without%20problems%3C%2FSPAN%3E%3C%2FSPAN%3E%2C%20%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3Ehas%20been%20tested%3C%2FSPAN%3E%3C%2FSPAN%3E.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20be%20happy%20to%20know%20if%20I%20could%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E*%20Kindly%20Mark%20and%20Vote%20this%20reply%20if%20it%20helps%20please%2C%20as%20it%20will%20be%20beneficial%20to%20more%20community%20members%20reading%20here.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1850409%22%20slang%3D%22en-US%22%3EBetreff%3A%20formula%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1850409%22%20slang%3D%22en-US%22%3EHi%20Nikolino%2C%3CBR%20%2F%3EIt%20still%20doesn't%20work%20%3CLI-EMOJI%20id%3D%22lia_disappointed-face%22%20title%3D%22%3Adisappointed_face%3A%22%3E%3C%2FLI-EMOJI%3E%3CBR%20%2F%3EMaybe%20there%20is%20something%20wrong%20with%20the%20settings%2C%20maybe%20you%20know%20something%20about%20that%3F%3C%2FLINGO-BODY%3E
Highlighted
New 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
Highlighted

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

Highlighted
Hi Nikolino,
It still doesn't work
Maybe there is something wrong with the settings, maybe you know something about that?
Highlighted
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
Highlighted

@Nikolino 

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

That's the answer of the question.

Highlighted
Best Response confirmed by chadiexcel (New 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.

Highlighted
thankyouu very much!!!!!!
Highlighted

@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)