Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

calculated value

Status
Not open for further replies.
brewer2

brewer2

Technical User
Apr 19, 2010
1
US
I have a column that put yes or no based on another column>
this is the code:
=IF(VoteScan="1","YES","NO")
that works but I also need it to check if it say YES.

How do I combine:
=IF(VoteScan="1","YES","NO")
=IF(VoteScan="YES","YES","NO")
 
Status
Not open for further replies.

Similar threads

akrshaw
  • Locked
  • Question
List Calculated Column - Count Text
Replies
1
Views
109
ehaze
ehaze
katoc
  • Locked
  • Question
Using a calculated Date field for Due Date in a Three-state workflow
Replies
2
Views
102
katoc
katoc
XMLCreator
  • Locked
  • Question
retrieve a list item value than add plus or minus 1 to the value next update the field w/ new value
Replies
0
Views
62
XMLCreator
XMLCreator
Skooshie
  • Locked
  • Question
Calculated Column Formula
Replies
0
Views
46
Skooshie
Skooshie
Jowidog
  • Locked
  • Question
SharePoint 2007 Calculated field displaying #DIV/0! How to suppress
Replies
4
Views
95
Jowidog
Jowidog

Part and Inventory Search

Sponsor

Back
Top