excel 2003 value change
Use the =IF function. Something like:
A B
1 CM
2 $100
3 =IF(OR(A1="CM",A1="RT"),-A2,A2)
hth
"narp" wrote:
I am looking for a function or formula that will allow me to do an IF Then
statement. For example, I want to say if cell B1 contains CM or RT then
make cell D1 negative value.
Any suggestions are greatly appreciated.
--
narp
|