Excel - IF Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

if K2 is less than 0, then I2. But if greater than 0, then K2(or leave as it is)
Solved by E. S. in 19 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 02/07/2018 - 02:17
Hi
Excelchat Expert 02/07/2018 - 02:17
Welcome to Got It Pro.
User 02/07/2018 - 02:18
hi
Excelchat Expert 02/07/2018 - 02:18
You are looking for if condition to get I2 value based on K2?
Excelchat Expert 02/07/2018 - 02:19
=if(K2<0,I2,K2)
Excelchat Expert 02/07/2018 - 02:19
Hi, there?
User 02/07/2018 - 02:23
i need L2 value, k2 is a mixture of positives and negatives. If K2 is negative, i want L2 to assume the figure in I2, if it's positive L2 should leave figure in K@ unchange
User 02/07/2018 - 02:23
**K2 unchanged**
Excelchat Expert 02/07/2018 - 02:24
=if(K2<0,I2,K2)
Excelchat Expert 02/07/2018 - 02:24
Please use this in L2 cell.
Excelchat Expert 02/07/2018 - 02:24
When K2 is negative, L2 will read I2 value.
Excelchat Expert 02/07/2018 - 02:25
If K2 is positive, then L2=K2.
User 02/07/2018 - 02:29
Wow!!! Pls do where are you located?
Excelchat Expert 02/07/2018 - 02:29
Hi, Thank you. We are not supposed to convey our personal details as per the policies.
Excelchat Expert 02/07/2018 - 02:29
Sorry about that.
User 02/07/2018 - 02:30
idrela@yahoo.com
Excelchat Expert 02/07/2018 - 02:30
Great to hear that you got the solution.
Excelchat Expert 02/07/2018 - 02:30
Please visit Got IT Pro for new queries. Have wonderful day ahead.
User 02/07/2018 - 02:31
because i have more, and need some to sort of help me build a template
Excelchat Expert 02/07/2018 - 02:32
Please visit Got It Pro for new queries. we have 24 * 7 support.
User 02/07/2018 - 02:33
Ok, thanks a lot. Are there charges for more queries?
Excelchat Expert 02/07/2018 - 02:34
Yes. There are packs available.
Excelchat Expert 02/07/2018 - 02:34
Please register and opt for the pack you are looking for.
User 02/07/2018 - 02:36
ok, will do just that! I certainly need you guys. I need to build a template and connect working documents together.
Excelchat Expert 02/07/2018 - 02:36
Ok. Great to hear. Thank you. Please visit Got It Pro.
Excelchat Expert 02/07/2018 - 02:36
Please end the session. Looks like you have extended it.

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.