Started By
Message
re: Who Holds the Record For Most Posts on this Site?
Posted on 12/27/14 at 12:46 am to OBReb6
Posted on 12/27/14 at 12:46 am to OBReb6
=IF(test/condition, value if true, value if false)
So say you have a column A with a bunch of values, posts if you will. You want to say that posters with more than 10,000 posts have no life, those under have a life.
B1 would be =IF(A1>10000, "Has no life", "Has a life")
So say you have a column A with a bunch of values, posts if you will. You want to say that posters with more than 10,000 posts have no life, those under have a life.
B1 would be =IF(A1>10000, "Has no life", "Has a life")
This post was edited on 12/27/14 at 12:50 am
2
Posted on 12/27/14 at 12:48 am to KSGamecock
Interesting. Whenever I dig through estimate sheets at work that is always the function that I couldn't figure out
Posted on 12/27/14 at 12:54 am to KSGamecock
Our sheets show an IF function to produce a uniform material cost per pound of differing material types. Always stumped me, but that's why I'm not in estimating.
Page 1 of 1
Popular
Back to top
Follow SECRant for SEC Football News