Hey everyone,
First time with an IF formulas.
A1=5
IF B1=2pk
C3=5/4
Please help.
Hey everyone,
First time with an IF formulas.
A1=5
IF B1=2pk
C3=5/4
Please help.
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks