Calculate formula base of list menu

rkeles · #1 09-21-2010, 05:19 AM

Quote:

Originally Posted by Kimberly

=HLOOKUP(E6,$A$2:$C$3,2,0)*D6
in cell G6 and copy down

By the way, you are multiplying in column G, but doesn't the label in cell G5 imply division?

Thanks Kimberly,
It works exactly what I want..

But I used it in Table, its give me #N/A error when i dont enter a value other cell.. (because of empy cell)

is there any solision for this error. on bottom of table I can not get the sum of amount because of this error. I want it to calculate empty cell as "0"

is it possiable...

thanks..

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Can't calculate formulas	Cpat	Excel	2	06-09-2010 02:07 PM
How do I set up the fields in mail merge word 07 from my data base	mbcrabber	Mail Merge	4	06-06-2010 01:25 PM
Need help creating a data base for mail merge.	acedking90	Mail Merge	0	07-27-2009 11:04 AM
Calendar Base	prayojana	Project	0	11-12-2007 01:13 AM
How to get cells to calculate time?	jrasche2003@yahoo.com	Excel	2	02-09-2007 07:10 AM