Excel - IF Function Problem - Expert Solution

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

Hi, For a budget calculation I want to create a condition. If A2 doesn't equal the word "income", C2 should be turned into a negative number (multiplied by (-1) I can't figure out the right formula
Solved by V. B. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 15/09/2018 - 02:39
Welcome to ExcelChat!
User 15/09/2018 - 02:39
hi
Excelchat Expert 15/09/2018 - 02:40
I see that your problem is about changing the cell value based on another cell
Excelchat Expert 15/09/2018 - 02:40
I will help you with the problem and explain the solution afterwards.
User 15/09/2018 - 02:40
great, thank you
Excelchat Expert 15/09/2018 - 02:40
Before we get started, this is a reminder that our policy is one problem per session with additional Q&A on that problem as time allows.
Excelchat Expert 15/09/2018 - 02:40
Let me ask you a couple of quick questions to make sure I fully understand your problem.
User 15/09/2018 - 02:40
alright
Excelchat Expert 15/09/2018 - 02:41
You mentioned that if A2 doesn't have the word income, C2 value should become negative
User 15/09/2018 - 02:41
right
Excelchat Expert 15/09/2018 - 02:41
The values in column C are typed in as values, or do they have formulas which make the result?
User 15/09/2018 - 02:42
they're typed in as values
Excelchat Expert 15/09/2018 - 02:43
The problem is that we won't be able to have the values in the cell and the formula which will turn them negative
Excelchat Expert 15/09/2018 - 02:43
But we can make another column, which will get the value from column C and make it negative
Excelchat Expert 15/09/2018 - 02:43
If condition in column A is followed
Excelchat Expert 15/09/2018 - 02:44
So we can have column D, which will equal to column C. If column A doesn't have the word income, the column D will equal the value of column C but with negative value
User 15/09/2018 - 02:44
okay
User 15/09/2018 - 02:44
What about a condition?
Excelchat Expert 15/09/2018 - 02:44
Okay, I will make the solution for you in column D
Excelchat Expert 15/09/2018 - 02:45
If column A has income, then column D values equal to column C. If column A doesn't have it, then it will be negative value of column C
User 15/09/2018 - 02:45
I can use conditional formatting to turn C2 red if A2 doesn't have the the word income
Excelchat Expert 15/09/2018 - 02:45
Yes, we can do it
User 15/09/2018 - 02:45
is it not possible to use the same conditional formatting to turn the number into a negative number?
Excelchat Expert 15/09/2018 - 02:45
Will it be a better solution for you?
Excelchat Expert 15/09/2018 - 02:46
No, sorry, not possible
User 15/09/2018 - 02:46
I see
Excelchat Expert 15/09/2018 - 02:46
So we will make a solution in column D, right?
User 15/09/2018 - 02:46
right
Excelchat Expert 15/09/2018 - 02:47
Okay, your solution is ready at column D
Excelchat Expert 15/09/2018 - 02:47
The formula which we used is the following:
Excelchat Expert 15/09/2018 - 02:47
=if(A1="income",C1,-C1)
Excelchat Expert 15/09/2018 - 02:47
So if column A has word income, we get the value of column C, otherwise we get the negative value of column C
User 15/09/2018 - 02:48
Alright, thanks for that
Excelchat Expert 15/09/2018 - 02:48
You are welcome!
Excelchat Expert 15/09/2018 - 02:48
Do you have any other questions about this problem and the solution?
Excelchat Expert 15/09/2018 - 02:49
Thanks for coming to Excelchat. Feel free to leave any comments or feedback. Have a nice day!
User 15/09/2018 - 02:58
Sorry, I got diconnected
User 15/09/2018 - 02:58
I actually found another solution, maybe you can use it in future sessions
Excelchat Expert 15/09/2018 - 02:59
Yes, what is 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.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc