• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Reference cell replace with negative symbol

Monty

Well-Known Member
Hello everybody.

Very bad took almost 5 hours spent still not achieved...Sorry no attachment as working on mobile.

We have two sheets in sheet2 we have 100 as positive number and it is referred in sheet1 with that cell.... Obviously it shows 100 as a result as u linked from sheet2 to sheet1..

Now question is... I wanted to retain the reference of sheet2 to sheet1 but wanted to show in negative.

Simple wanted result with VBA

Pre
= Sheet2 F8

Post
=-sheet2 F8

Hopefully not confused...I tried all the ways to do it...Having a beer to relax now.

Thanks.
 
Back
Top