Changing number to negative based on another cell value

[pelachrum]

Could anyone help me write this VBA...

I have numbers (all positive) in column D and either "debit" or "credit" in column E
I'd like to turn the positive number into negative if its corresponding row E column cell states "debit".
If it says "credit" in E, the number would be left unchanged, ie. positive.

Thanks so much

[stnkynts]

Either one will work. Just depends on how you want to implement it:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[jeffreybrown]

Try...

Please Login or Register  to view this content.

[pelachrum]

thanks, it worked

[jeffreybrown]

You're welcome…glad you have a workable solution and thanks for the feedback...

NOTE: Just so we know, what worked for you...

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

[pelachrum]

One followup...

I'm using :

Please Login or Register  to view this content.

If occasionally, I end up with a value in E that's neither debit or credit, how do I state a Case that would accept "anything else" as value?

[stnkynts]

Use Case Else

Please Login or Register  to view this content.

[pelachrum]

Thank you, that's the one