software

Hey everyone,First time with an IF formulas.

A1=5
IF B1=2pk
C3=5/4
Please help.--
jwfakouri
------------------------------------------------------------------------
jwfakouri's Profile: www.excelforum.com/member.php...oamp;userid=31435
View this thread: www.excelforum.com/showthread...hreadid=511581
Maybe something like:

in C3
=IF(B1=quot;2pkquot;,A1/4,0)

basic of formula
IF(condition, if true, if false)

condition - B1 = quot;2pkquot; ....will calculate to TRUE or FALSE
if true - A1/4 or any value you want returned
if false - 0 or quot;quot; to return a blank cell or any value you want
returned

Hope this helps!
Jean-Guy--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: www.excelforum.com/member.php...foamp;userid=6261
View this thread: www.excelforum.com/showthread...hreadid=511581