I am going to try and make this as simple as possible. I have been
working on an excel sheet and have been stumped with this problem:

I am working with stock options. Therefore I must subtract the current
stock price Cell C2, which has a value of 23 with the Options price
which is D9, has a value of 34.79 then muliply it with the shares which
is cell F9 which is 4000. So the formula that i have is (C2-D9)*F9 that
gives me the sum which resides in cell I9(total outstanding
profit).......This turns out to be a negative number. I want to make it
so that if the sum of that formula produces a negative number, i want
that negative number to just become a "0". Ive tried the IF function
but could not produce any results. HELP ME PLEASE!!!!


--
jrabs12
------------------------------------------------------------------------
jrabs12's Profile: http://www.excelforum.com/member.php...o&userid=37194
View this thread: http://www.excelforum.com/showthread...hreadid=569032