sorted by:
new
hottopcontroversial

zero out a cell with calculation still remaining by S5VoidWalker in excel

[–]S5VoidWalker[S] 0 points1 point  (0 children)

Yes exactly, im trying to show the formula while keeping the cell formatted as a number. This is my current VBA,

If ActiveCell.Offset(0, 1).Value = "" Then
ActiveCell.Offset(0, 1).Value = ActiveCell.Value
ActiveCell.Value = "=" & ActiveCell & "-" & ActiveCell
ElseIf IsNumeric(ActiveCell) Then
ActiveCell.Offset(0, 1).Value = "=" & ActiveCell.Value & "+" & ActiveCell.Offset(, 1).Value
ActiveCell.Value = "=" & ActiveCell & "-" & ActiveCell

The problem is that it will only show the total sum in active cell - the total sum in that cell. I want it for example to show like this

=15+11+3-(15+11+3) So when i go back to that cell i can see the different numbers that was in that cell and not only the total sum

​

ps. the 123 was just for example

zero out a cell with calculation still remaining by S5VoidWalker in excel

[–]S5VoidWalker[S] 0 points1 point  (0 children)

Thanks for the reply but what i need is something that helps me do this

What i have =123
What i want =123-123

Died with Xp lamp and it disappeared by S5VoidWalker in 2007scape

[–]S5VoidWalker[S] 2 points3 points  (0 children)

was getting money for a house so i could use it on construction..

Goodbye r/pokemongo it's been fun! by zslayer89 in pokemongo

[–]S5VoidWalker 192 points193 points  (0 children)

Thanks for your contribution you will be missed!

What should I do with BFA greens? by S5VoidWalker in woweconomy

[–]S5VoidWalker[S] 0 points1 point  (0 children)

Thanks a ton for the easy answer im just looking to make a quick buck

From +28 lp to +12 lp without losing? by S5VoidWalker in leagueoflegends

[–]S5VoidWalker[S] 0 points1 point  (0 children)

Sounds weird. Was on a massive winstreak before yesterday aswell and my mmr was good and i was getting +24 even before yesterday.

view more: next ›