Posted to microsoft.public.excel.worksheet.functions

Mary

external usenet poster

Posts: 190

Lookup function

Hi all,
This is driving me crazy. I am trying to make up this formula
=IF(E2= 1 and G2 = 20.72 or less its "ok". If over 20.72 subtract G2 from
20.72 and total)
Then if E2 = 2 and G2 is 41.44 or less its "ok". If over 20.72 subtract G2
from 41.44 and total)
I have 15 numbers to do this way .

Any help will really be appreciated.

I am new to this an am not sure what I need to show you

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
how to combine an IF Function with a lookup function to determine	[email protected]	Excel Worksheet Functions	1	December 5th 06 06:09 AM
lookup function	Susan	Excel Worksheet Functions	3	April 19th 06 04:46 PM
LOOKUP FUNCTION	Mer	Excel Worksheet Functions	1	February 21st 06 02:11 AM
LOOKUP function	haroldhagar	Excel Worksheet Functions	2	August 6th 05 07:38 PM
Pivot table doing a lookup without using the lookup function?	NGASGELI	Excel Discussion (Misc queries)	0	August 2nd 05 05:08 AM

All times are GMT +1. The time now is 11:42 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us