Dave O.

Posts: n/a

"False" filling in the blank spaces

I have used the following formula in a commission report.
=IF((D5<"")*(E5<""),LOOKUP(E5,{3,3.15,3.25,3.35, 3.45,3.55,3.65,3.75},{0.38,0.43,0.46,0.49,0.52,0.5 6,0.59,0.62})*D5-H5)

When the spaces referenced above are blank i get a "false" in the blank.
Can I change it so the false is blank to keep the sheet clean?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
blank cells	R.VENKATARAMAN	Excel Discussion (Misc queries)	1	April 6th 05 10:25 AM
Grouped Sheets and Formating	Pank Mehta	Excel Discussion (Misc queries)	3	March 24th 05 01:42 AM
link data to new workbook	WYN	Excel Discussion (Misc queries)	3	February 28th 05 06:19 AM
Grand Totals @ Same Place	Amber M	Excel Worksheet Functions	2	December 30th 04 07:13 PM
Paste Special in a macro	CMAC	Excel Worksheet Functions	2	December 6th 04 10:19 PM

All times are GMT +1. The time now is 04:34 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us