If statement, answer is false, hide false.

**Mel B** · 02-06-2013, 05:01 PM

In the following formula I want the "false" answer to not be printed in the appropriate cell.

=if(D8="c",c8)

Thanks

Mel B

**alansidman** · 02-06-2013, 05:04 PM

If you wish the cell to be blank, then
=if(D8="c",c8,"")

**Mel B** · 02-06-2013, 06:04 PM

Thanks for the guidance, however, there is always a however, later in the spread sheet the "blank" cell is sumed or + to another cell and the #value! error message comes up???

Mel

**alansidman** · 02-06-2013, 06:10 PM

suggest you post your spreadsheet sanitized for confidential material so that we can see the whole picture. Difficult to determine what is happening without seeing everything.

**Mel B** · 02-06-2013, 06:16 PM

New user, Thank you, will post the spread sheet.

Mel

**Mel B** · 02-07-2013, 06:35 PM

Thanks again for guidance, however, this newby to both Excel and this web site found it easier to figure out the answer than to figure out how to post a portion of my spread sheet to this site. Next question. Does Microsoft Excel 2007 have the ability so that one could click on a cell and a drop down box would appear with various options that can be chosen for the cell?