+ Reply to Thread

Results 1 to 2 of 2

If condition based on the values

LinkBack
- LinkBack URL
- About LinkBacks
Thread Tools
- Show Printable Version
- Subscribe to this Thread…
Rate This Thread
- Current Rating
- ‎ Excellent
- ‎ Good
- ‎ Average
- ‎ Bad
- ‎ Terrible
Display
- Switch to Linear Mode
- Hybrid Mode
- Switch to Threaded Mode

Hybrid View

11-17-2014, 07:27 AM #1
Crooza

View Profile

View Forum Posts
Forum Expert

Join Date

10-19-2013

Location

Hunter Valley, Australia

MS-Off Ver

Excel 2003 /7/10

Posts

2,082
Re: If condition based on the values

Try

=if(A2="vacant","vacant seat",if(A2="","not ok","ok"))

Happy with my advice? Click on the * reputation button below
Register To Reply

+ Reply to Thread

« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

Pick out top ten values based on 1 condition

By batchjb69 in forum Excel Programming / VBA / Macros

Replies: 3
Last Post: 06-10-2014, 08:52 AM
Average Values based on Condition

By flyn in forum Excel Programming / VBA / Macros

Replies: 2
Last Post: 03-28-2011, 09:23 AM
Retrieve values based on two condition

By roshankp in forum Excel Programming / VBA / Macros

Replies: 4
Last Post: 08-10-2010, 06:04 AM
Sum the values in cells based on the condition

By deviaug28 in forum Excel Formulas & Functions

Replies: 3
Last Post: 12-04-2009, 08:14 PM
Add values in a column based on condition

By finder003 in forum Excel Formulas & Functions

Replies: 1
Last Post: 06-28-2007, 07:16 PM

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions

You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off

All times are GMT -4. The time now is 04:55 AM.

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1