If two cells contain any values then return TRUE

**djarcadian** · 11-13-2014, 01:38 PM

What would the formula be if I want to return TRUE if two cells contain values (i.e. they're not blank). If neither cell or only just one of the cells contain a value then it would return FALSE.

**Ron Coderre** · 11-13-2014, 01:42 PM

This formula returns FALSE if either referenced cell is blank...Otherwise: TRUE

Please Login or Register  to view this content.

Is that something you can work with?

**djarcadian** · 11-13-2014, 03:36 PM

Yes, that's perfect. Thanks.

If two cells contain any values then return TRUE

LinkBack

Thread Tools

Rate This Thread

Display

If two cells contain any values then return TRUE

Re: If two cells contain any values then return TRUE

Re: If two cells contain any values then return TRUE

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Return TRUE if 1st 2 characters in text are alpha values

How to return multiple values in multiple cells if argument is TRUE in IF functions?

How do you search for whole words within cell to return true/false values?

Excel 2007 : Return 'TRUE' for cells that contain a letter?

if multiple values same/others different, return true

Bookmarks

Bookmarks

Posting Permissions