or just custom format
0;-0;;@
or just custom format
0;-0;;@
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Here is the situation i am stuck with. I have two tabs in the excel attached, one is Linked tab and the other is Destination tab and
here is what i want to see the result in the Linked tab -
If cell D2 in Destination tab is blank, i want to see cell D4 in Linked tab blank without any zero or '-'.
If cell E2 in Destination tab is zero or '-', i want to see cell E4 in Linked tab as zero or '-'.
Could you please help resolving this?
Thanks
Hello,
hope this can help you,
I putted =REPLACE('Destination tab'!D2,1,0,"") in linked tab!D4
and =REPLACE('Destination tab'!E2,1,0,"") in linked tab! E4
and got the result you were waiting for.
With this function here i replace zero but you can do the same with anything.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks