Posted to microsoft.public.excel.worksheet.functions

Sri Harsha[_2_] Sri Harsha[_2_] is offline

external usenet poster

Posts: 24

Multiple Logics to be looked at

I am preparing an estimates tool. I have 5 different products and each has 2
types of deliverables, RN and UG.
In a table we have estimates for each product individually.
Now, i am looking for a formula which has to first see the product, then the
severity of the defect, lookup the estimated hours and multiply the no. of
defects/pages with the estimates and give. Any suggestion?

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
Creating a formula that uses multiple logics.	rpalmer32	New Users to Excel	6	September 24th 08 04:48 PM
filters logics	abarwinski	Excel Worksheet Functions	0	September 16th 05 11:53 AM
offset a looked up cell	tiggz13	Excel Discussion (Misc queries)	2	June 24th 05 03:26 PM
offset a looked up cell	Buffett	Excel Discussion (Misc queries)	1	March 29th 05 07:07 PM
VBA: Looked up data / now how do I change it?	Mcasteel	Excel Worksheet Functions	1	October 29th 04 06:25 PM

All times are GMT +1. The time now is 02:06 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us