How to change the sign of number based on condition in same cell in large data

Copper Contributor
Please Help me
How to change the sign of number based on condition in same cell in large data

If I use Paste special with multiply by -1 after filter than it change take place in invisible cell also
Thank you
1 Reply

@Sonu975 

 

I think what you're asking is probably relatively simple, BUT your description is somewhat confusing, so rather than continue and exacerbate the confusion with a solution that may not fit at all, I need to ask you to post a spreadsheet that represents the reality you're dealing with. It's hard to describe things fully accurately in words; so the  real thing helps a lot.

 

And please, an actual spreadsheet rather than an image. If your real one includes confidential information, then post a file that takes that confidential info out.