Hello friends,
I have multiple column to mutiply. If the column is blank than I want to display blank instead of 0 (zero). How can I do this? Please suggest.
The sample file is also attached.
Indra
Hello friends,
I have multiple column to mutiply. If the column is blank than I want to display blank instead of 0 (zero). How can I do this? Please suggest.
The sample file is also attached.
Indra
Last edited by indra; 08-23-2010 at 06:30 AM.
Hi,
How about this?
=IF(A2*2+B2*2+C2*2+D2*2=0,"",A2*2+B2*2+C2*2+D2*2)
Rule 1: Never merge cells
Rule 2: See rule 1
"Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".
Yes, Very nice. Thank you for your kind support.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks