jrabs12 Wrote:
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!!!!
Hi jrabs12,

Try this formula

=IF((C2-D9)*F9<=0,0,C2-D9)*F9

This says at if your result is less than or equal to zero, display
zero, otherwise result is positive

oldchippy ;)


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