Nested If statements. I wanted blank/empty cells to not show 0

Please see attached workbook. I know for a fact this isn't the most effective way to do this, but I just needed something really quick for a small worksheet that my department at work is using. A1:C7 are supposed to represent 3 different types of "methods" In the case of my worksheet, I just typed random stuff.

Basically, I have data validation in B10. Depending on which one I select (1 corresponds with A1:A7, 2 with B1:B7, and 3 with C1:C7), it is supposed to populate that data. I've done this with nested if statements in D10:D16. The issue is that for options 2 and 3, it shows 0's where the blanks should be. Any quick fixes to this?

I must note that I'm not to savvy with VB/coding.

Thank you,

Try wrapping your nested IF function in the T function..

=T(yourifformula)


This only works for Textual results of the IF function.

Format ALL of column D as a number, with the following format: #

That way any zeroes will be formatted as blanks!

HTH

Tony

Success. Thanks!