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 Chriss Miller 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
Joined
Apr 19, 2010
Messages
1
Location
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 Question
List Calculated Column - Count Text
Replies
1
Views
291
ehaze
ehaze
katoc
  • Locked
  • Question Question
Using a calculated Date field for Due Date in a Three-state workflow
Replies
2
Views
347
katoc
katoc
XMLCreator
  • Locked
  • Question 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
198
XMLCreator
XMLCreator
Skooshie
  • Locked
  • Question Question
Calculated Column Formula
Replies
0
Views
143
Skooshie
Skooshie
Jowidog
  • Locked
  • Question Question
SharePoint 2007 Calculated field displaying #DIV/0! How to suppress
Replies
4
Views
297
Jowidog
Jowidog

Part and Inventory Search

Sponsor

Back
Top