Thread: If functions
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
LAndersen LAndersen is offline
external usenet poster
 
Posts: 4
Default If functions

This is what I'm trying to do:

In column E I have a number ($ - and can be negative or positive numbers)
and in column F I have a percentage. I want to extract all informational
data on columns A through F in which column E is either greater or less than
+/- $3700 OR in which column F is greater than +/- 20%.

Essentially, the results would then NOT include anything under +/- $3700 AND
also under 20%.

Thanks.