Formating Existing Formula to Return Blank Insted of 0

[jmsutod]

I'm starting with the following formula:

=INDEX(Raw!P:P,ROUNDUP((ROWS(D$2:D24))/9,0)-1+2)

Is it possible to nest or add something to this so that it returns a blank instead of a zero?

Thanks for your help

The Noob-Jonathan

 

[tc88]

I'm starting with the following formula:

=INDEX(Raw!P:P,ROUNDUP((ROWS(D$2:D24))/9,0)-1+2)

Is it possible to nest or add something to this so that it returns a blank instead of a zero?

Thanks for your help

The Noob-Jonathan

Not the prettiest way, but:

=IF(=INDEX(Raw!P:P,ROUNDUP((ROWS(D$2:D24))/9,0)-1+2)=0,"",INDEX(Raw!P:P,ROUNDUP((ROWS(D$2:D24))/9,0)-1+2)

 

[T. Valko]

Not the prettiest way, but:

=IF(=INDEX(Raw!P:P,ROUNDUP((ROWS(D$2:D24))/9,0)-1+2)=0,"",INDEX(Raw!P:P,ROUNDUP((ROWS(D$2:D24))/9,0)-1+2)

Ya probably want to take that 2nd equal sign out of there.

The perils of copying and pasting!

 

[jmsutod]

Worked like a charm, despite its utter lack of sex appeal. Thanks!!

 

[tc88]

Worked like a charm, despite its utter lack of sex appeal. Thanks!!

Thanks for the feedback. If someone has a more economical approach feel free to post it, I'm always interested in new ways to attack problems.

 

[T. Valko]

Thanks for the feedback. If someone has a more economical approach feel free to post it, I'm always interested in new ways to attack problems.

A possibility...

You could use the original short formula and apply a custom format to hide the display of 0 values.

Format the cells as: [=0]"";General

The cells will still contain numeric zeros, you just won't see them.