# Excel - COLUMN Function Problem - Expert Solution

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

I need a formula that only shows when i go over a number Like coulmn B4 is340700 and C4 is 341500 total diffrence is 800 in coulmn D4 and in column E4 shows the its -8200 I dont want it to show a number unless its over 9000. Can that be done?
Solved by C. B. in 26 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 04/09/2018 - 06:12
Hi
Excelchat Expert 04/09/2018 - 06:13
User 04/09/2018 - 06:13
hi
Excelchat Expert 04/09/2018 - 06:13
Please share the sample in the preview.
User 04/09/2018 - 06:13
Did you under stand my question
Excelchat Expert 04/09/2018 - 06:14
Do you want to consider absolute value of the difference?
Excelchat Expert 04/09/2018 - 06:15
How E4 will be changed to -8200 based on D4 value?
User 04/09/2018 - 06:15
I only wwant to see what is over the 9000 and not the - value
Excelchat Expert 04/09/2018 - 06:15
D4=C4-B4
Excelchat Expert 04/09/2018 - 06:16
How E4 is calculated?
Excelchat Expert 04/09/2018 - 06:16
How you are getting -8200?
Excelchat Expert 04/09/2018 - 06:16
I can add a condition to control the number to display only above 9000?
Excelchat Expert 04/09/2018 - 06:16
=if(E4>9000,E4,0)
Excelchat Expert 04/09/2018 - 06:17
I have added a formula in F4 cell.
User 04/09/2018 - 06:18
If I take 340700-341500=800 but i only want to should the diffence after 9000 in the next column
Excelchat Expert 04/09/2018 - 06:18
Ok.
User 04/09/2018 - 06:19
will it make it easier if I call you
Excelchat Expert 04/09/2018 - 06:19
=if(C4-B4>9000,C4-B4,0)
Excelchat Expert 04/09/2018 - 06:19
Please check the formula. You can change the number in B4 and it results when the difference is >9000.
User 04/09/2018 - 06:20
ok i will try it
Excelchat Expert 04/09/2018 - 06:20
Sure.
User 04/09/2018 - 06:22
it just said true
Excelchat Expert 04/09/2018 - 06:24
When the difference of C4 and B4 is greater than 9000, then it shows the difference of C4 and B4. Else, it is zero.
User 04/09/2018 - 06:24
and 0 is fine if it doesnt go over
Excelchat Expert 04/09/2018 - 06:24
Please check in preview the result and formula in D4 cell.
Excelchat Expert 04/09/2018 - 06:25
B4 and c4 are inputs.
User 04/09/2018 - 06:25
Excelchat Expert 04/09/2018 - 06:25
User 04/09/2018 - 06:26
let me know if you can open it
Excelchat Expert 04/09/2018 - 06:26
Ok. I am checking
Excelchat Expert 04/09/2018 - 06:27
Ok. Where do i need to write the formula?
User 04/09/2018 - 06:27
colum e4
Excelchat Expert 04/09/2018 - 06:28
Ok. I have updated the formula.
Excelchat Expert 04/09/2018 - 06:28
Excelchat Expert 04/09/2018 - 06:28
.
User 04/09/2018 - 06:30
ok that looks good I will try it on my page and let you know if you have a minute
Excelchat Expert 04/09/2018 - 06:30
Sure. Please try. You can use the same file.
User 04/09/2018 - 06:33
Great it worked
Excelchat Expert 04/09/2018 - 06:33
Good to hear.
Excelchat Expert 04/09/2018 - 06:33
Please visit Got IT Pro for new queries.
Excelchat Expert 04/09/2018 - 06:33
Excelchat Expert 04/09/2018 - 06:33
Please end the session and leave a great feedback.
User 04/09/2018 - 06:34
Thank you so much
User 04/09/2018 - 06:34
If I was to sign up for this do you also do it over the phone?
Excelchat Expert 04/09/2018 - 06:35
We don't such facility at the moment. We offer solutions through chat mode.
User 04/09/2018 - 06:35
Well it worked so I just might sign up because you were quick
User 04/09/2018 - 06:36
Thank you again
Excelchat Expert 04/09/2018 - 06:36
That is great to hear. Thank you.
Excelchat Expert 04/09/2018 - 06:36
Please attach sample file, next time to get more quick response.
User 04/09/2018 - 06:36
I will do that Thank you
User 04/09/2018 - 06:37
Can I give you another one lol
Excelchat Expert 04/09/2018 - 06:37
Hi, We offer one solution per session as per the policy.
User 04/09/2018 - 06:38
Thats ok Thanks again I think I will be signing up soon Have a great day
Excelchat Expert 04/09/2018 - 06:38
We have 24 * 7support.
Excelchat Expert 04/09/2018 - 06:38
So, any time you can post a problem and visit any time.
User 04/09/2018 - 06:38
Nice even better
Excelchat Expert 04/09/2018 - 06:38
Thank you
User 04/09/2018 - 06:38
bye
Excelchat Expert 04/09/2018 - 06:38
Bye.
Excelchat Expert 04/09/2018 - 06:38

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.