Solved
How do I get the retrieved value changed automatically to either a plus or a minus in Excel 2007?
Posted on 2016-09-30
I have this formula for retrieving a value:
=Index(Travbanor!A6:A100;Match(C1;Travbanor!B6:B100;0))
The retrieve value might be a minus value, a 0 or a plus value. If a minus value or a plus value the minus/plus should be reverted to the opposite, if a zero nothing should happen.