Thanks:  0
Likes:  0

# Thread: #VALUE - I WOULD LIKE DO DISPLAY BLANK CELL

1. B16 IS BLANK
C16 IS BLANK
D16 IS BLANK
E16 =IF(ISNA(LOOKUP(B16,\$N\$16:Q\$34)),"",LOOKUP(B16,\$N\$16:\$Q\$34))
F16 =IF(ISNA(LOOKUP(B16,\$N\$16:R\$34)),"",LOOKUP(B16,\$N\$16:\$R\$34))
G17=IF(ISNA(LOOKUP(B16,\$N\$16:\$S\$34)),"",LOOKU(B16,\$N\$16:\$S\$34))
L16 =C16*E16
DISPLAYS #VALUE!
HOW DO IS DISPLAY BLANK CELL (REQ'D FOR FORM, THAT I WOULD LIKE TO LEAVE ALL FORMULAS IN

2. On 2002-03-31 18:58, HAWK wrote:
B16 IS BLANK
C16 IS BLANK
D16 IS BLANK
E16 =IF(ISNA(LOOKUP(B16,\$N\$16:Q\$34)),"",LOOKUP(B16,\$N\$16:\$Q\$34))
F16 =IF(ISNA(LOOKUP(B16,\$N\$16:R\$34)),"",LOOKUP(B16,\$N\$16:\$R\$34))
G17=IF(ISNA(LOOKUP(B16,\$N\$16:\$S\$34)),"",LOOKU(B16,\$N\$16:\$S\$34))
L16 =C16*E16
DISPLAYS #VALUE!
HOW DO IS DISPLAY BLANK CELL (REQ'D FOR FORM, THAT I WOULD LIKE TO LEAVE ALL FORMULAS IN
Try
L16 =IF(E16="","",C16*E16)

3. Or similar way is...

L16 =IF(ISBLANK(E16),"",C16*E16)

4. Hi Hawk

As you are gettin the #VALUE! error the problem is most likely stemming from one of the cells containig Text. Try this

=IF(OR(ISTEXT(C16),ISTEXT(E16)),"",C16*E16)

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•