I have a report which is imported from external data and comprises of
relevant Sales orders and purchase orders for specific product items. The
data when in the file format does not show negative figures. I would like to
use Excel to look at say cell A1 and if this is an SOR* then for the returned
figure to be *-1 which would then allow me to distinguish between the
positive and negative thus producing a bottom line amount of the exact
product item stock figure. I have tried to use the IF function but all that
is returned are blank cells. So far I've tried: =IF($A1=SOR*,H1*-1,"") which
seemed favourite but doesn't work, which function should I be using?
Thanks