min and if statement

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: RichardO (RichardO.14d1tc_at_excelforum-nospam.com)
Date: 04/07/04 

Date: Wed, 7 Apr 2004 15:54:50 -0500

Hello all:

How do I find the min value in a column with 2 if conditions.

I have the following formula: Min(data!$R:$R)

I have items in column W such as pay, auto e.t.c. and dollar amounts in
column L. I want excel to find the min in column R for everything
EXCEPT for cases where column W and column L have "pay" AND amount $
dollar amount less than "250" respectively.

Thanks for your help.

RichardO. 

---
Message posted from http://www.ExcelForum.com/
Quantcast