Assuming these are hard coded values and not wildcard expressions

IF(A1="SOR*","*-1","")

I don't know why H1 was there, formulas can only return result in the cells
that hold them so if you meant that H1 should return *-1 then you must put
the formula in H1


--
Regards,

Peo Sjoblom


"deniseh" wrote in message
...
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