Hi - I thought I wrote the formula right but its not working. I want "yes" to appear if a cell contains a value of 35 or more. I want the same cell to say "no" if it is less than 35. Here is what I have so far:
=IF(AND($C3=">=35"),"YES","NO")
Any value just says no. Please advise.
Thanks.
=IF($C3>=35,"YES","NO")
Try this
Windows 7 using Office 2007 & 2010
Remember your [ code ] [ /code ] tags, makes reading soooo much easier
Great job. It's funny how a misplaced quotation mark and comma can really make Excel think you have no brain. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks