How to

eazyyexcel

New Member
Joined
Mar 1, 2021
Messages
20
Office Version
  1. 2016
Platform
  1. Windows
Hi there,

I have attached the excel file. I would like cell column D to display the total and plus and minus from column C. For example if column D balance is 40,000 And in column C is keyed in +10,000 then the balance will be 50,000 but if we key in -10,000 then the total will become 30,000. The formulas will be keyed in for column D.

Thank you
IMG_4184-min.jpeg
 
Perhaps your laptop has the wrong regional setting?

Windows key->Search for Settings->Date & Time->Make sure the region is set correctly. Otherwise I'm at a bit of a loss.

1725865896746.png
 
Upvote 0

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.
Thanks man I'll give it a shot.

I have another excel question but it is not related to the file we have been discussing. Shall I create a new thread or can I reply here?
 
Upvote 0
And eazy that's why you want to continue using this web page. There's always somebody smarter than me who will help us out. I do appreciate all the people who help out on this web page. Thanks myall
 
Upvote 0

Forum statistics

Threads
1,224,822
Messages
6,181,165
Members
453,021
Latest member
Justyna P

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top