Hi all,
I'm trying to make excel show minus values if a certain CELL is changed to another value.
So say in column B they change it from 'option A' to 'option B', when they then enter the numeric values in column D i'd like it to show a minus value instead - is this possible?
I've tried =IF(B1='option B',D1=*-1.... etc, but that's gibberish to excel.
suggestions/pointers greatly appreciated
Cheers,
Weasel.
Bookmarks