Change sign value based on other cell value

**amberle** · 06-25-2020, 05:29 AM

Good day...

Help me please...

A6:A9999 value = DEBIT or CREDIT
B6:B9999 value = Amount

if i change any value from A6:A9999
ex:
A6 = CREDIT
A10 = DEBIT

then it will change the amount sign of B6:B9999
ex:
B6 = -1,000.00
B10 = 5,000.00

Thanks...

**alansidman** · 06-25-2020, 05:46 AM

Here is a worksheet change event

Option Explicit

Please Login or Register  to view this content.

Open your VBE (Alt + F11), double click in the left window on the sheet you will be updating
Copy the above code and place it in the right window when it opens.

**davesexcel** · 06-25-2020, 05:48 AM

This could work using a worksheet_change event

Place this code in the worksheet module

Please Login or Register  to view this content.

**amberle** · 06-25-2020, 06:07 AM

Thank you guys... working great...
can you add also just in case column A value already filled with DEBIT or CREDIT then
if I type amount either negative or not then amount sign will automatically change
also based on column A value (vice versa)

**amberle** · 06-25-2020, 06:15 AM

Sir alansidman, it's work for one time changes only, but if I change it again the value in column A it didn't match
the amount sign

Change sign value based on other cell value

LinkBack

Thread Tools

Rate This Thread

Display

Change sign value based on other cell value

Re: Change sign value based on other cell value

Re: Change sign value based on other cell value

Re: Change sign value based on other cell value

Re: Change sign value based on other cell value

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Change the positive sign to negative sign in Pivot Table

[SOLVED] Formula:add degree sign min sign and sec sign to a cell

How to change the Dr./Cr. symbol to +Sign or -sign through formal cell in excel 2016

Create a formula based on a mathematical sign from another cell

Change sign of number based on validation drop down in another column

Reversing Sign Based on Cell being Manually Coloured

[SOLVED] how to change cell sign and values

Bookmarks

Bookmarks

Posting Permissions