I had values in all columns, C, D, and F. C is a letter and D, F are numbers.
I wrote my initial equation =IF(C9="S",(D9-F9),(F9-D9)) after having several
rows worth of data. Except for the actual row in which I tried my equation.
I left out the F column number. All said and done, the function works. I am
just an idiot for not checking all the fields first.
Thanks for trying to help me Vito.
"Vito" wrote:
Are all your cells formatted as numbers?
What result do you get if C9 is not "S"?
--
Vito
------------------------------------------------------------------------
Vito's Profile: http://www.excelforum.com/member.php...o&userid=29182
View this thread: http://www.excelforum.com/showthread...hreadid=489199