Harlan Grove

Posts: n/a

"Teri" wrote...
I copied this right into my spreadsheet and got an error message.
Is there a ( missing somewhere?

"Harlan Grove" wrote:
....
=IF(C2="","",VLOOKUP(E2,$J$2:$L$6,3)+ISNUMBER(C2 ),0.5,0))

No, there's a missing IF call. Make that

=IF(C2="","",VLOOKUP(E2,$J$2:$L$6,3)+IF(ISNUMBER(C 2),0.5,0))

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to 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
Average non continguous cells, excluding zero's	Keithlearn	Excel Worksheet Functions	2	April 27th 05 01:22 PM
Help adding text values	Texas-DC_271	Excel Worksheet Functions	7	January 15th 05 11:14 PM
To safety merge cells without data destroyed, and smart unmerge!	Kevin	Excel Discussion (Misc queries)	0	December 30th 04 07:17 AM
Automatic copying data excluding blank cells	Wesley	Excel Worksheet Functions	6	November 30th 04 01:17 AM
excluding cells from the formula when empty	Joe Shell	Excel Worksheet Functions	5	November 21st 04 04:37 PM

All times are GMT +1. The time now is 09:06 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us