Here is the problem.

I have a multi-tabbed sheet where the last tab contains lease factors
such as:

.0297
.02417
.02034

in a single column. Then there is a second column for a different type
of lease.

I have designed a sheet with 2 drop downs. Drop down "A" has 2 entries
in it returning a 1 or a 2 depending on the choice, and then Drop down
"B" has 7 entries in it for the various term lengths.

In plain english here is what I need to do:

IF Drop Down "A" is equal to 1 AND Drop Down "B" is equal to 1 AND
(some cell) is Greater Than 2999.99 THEN multiply (some cell) by the
appropriate rate on the Factors Page.

Wow. The IF function does not have enough depth to look at all of the
possibilities and I could not find a case function and I dont know VBA

Can anyone help me at all?


--
dexman
------------------------------------------------------------------------
dexman's Profile: http://www.excelforum.com/member.php...o&userid=31481
View this thread: http://www.excelforum.com/showthread...hreadid=511587