Expert Solution - Excel COLUMN Problems

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

Excelchat Expert 04/09/2018 - 06:13

It's pleasure to help you today.

User 04/09/2018 - 06:13

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

should I attach my spreadsheet

Excelchat Expert 04/09/2018 - 06:25

Please share it.

User 04/09/2018 - 06:26

let me know if you can open it

[Uploaded an Excel file]

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

Please download the file.

Excelchat Expert 04/09/2018 - 06:28

[Uploaded an Excel file]

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

Have a great day ahead.

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