Hey everyone, First time with an IF formulas. A1=5 IF B1=2pk C3=5/4 Please help.
J jwfakouri Feb 13, 2006 #1 Hey everyone, First time with an IF formulas. A1=5 IF B1=2pk C3=5/4 Please help.
P pinmaster Feb 13, 2006 #2 Maybe something like: in C3 =IF(B1="2pk",A1/4,0) basic of formula IF(condition, if true, if false) condition - B1 = "2pk" ....will calculate to TRUE or FALSE if true - A1/4 or any value you want returned if false - 0 or "" to return a blank cell or any value you want returned Hope this helps! Jean-Guy
Maybe something like: in C3 =IF(B1="2pk",A1/4,0) basic of formula IF(condition, if true, if false) condition - B1 = "2pk" ....will calculate to TRUE or FALSE if true - A1/4 or any value you want returned if false - 0 or "" to return a blank cell or any value you want returned Hope this helps! Jean-Guy
