#VALUE - I WOULD LIKE DO DISPLAY BLANK CELL

HAWK · Mar 31st, 2002, 07:58 PM

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

Ivan F Moala · Mar 31st, 2002, 08:07 PM

Quote:

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)

Colo · Apr 1st, 2002, 12:41 AM

Or similar way is...

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

Dave Hawley · Apr 1st, 2002, 12:49 AM

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)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 31st, 2002, 07:58 PM	#1
HAWK New Member Join Date: Mar 2002 Location: LIZ Posts: 19	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

Apr 1st, 2002, 12:41 AM	#3
Colo MrExcel MVP Join Date: Mar 2002 Location: Kobe, Japan Posts: 1,420	Or similar way is... L16 =IF(ISBLANK(E16),"",C16*E16)

Apr 1st, 2002, 12:49 AM	#4
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	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)