Thanks:  0
Likes:  0

# Thread: If / then function

1. I have been trying to enter a funtion into a cell to check that if that particular cell,from sheet 1, contains a lower total (number) than each of 4 to 5 totals in other cells on sheet 1, then the amount from another cell on sheet 1 is to be reflected in a cell on sheet 2. I'll reference cells in order to give you an idea of what I'm trying to do.
If (sheet1)A6

2. On 2002-03-13 10:32, Anonymous wrote:
I have been trying to enter a funtion into a cell to check that if that particular cell,from sheet 1, contains a lower total (number) than each of 4 to 5 totals in other cells on sheet 1, then the amount from another cell on sheet 1 is to be reflected in a cell on sheet 2. I'll reference cells in order to give you an idea of what I'm trying to do.
If (sheet1)A6 < B6,C6,D6,E6 AND F6, then reflect the number contained in (sheet 1) A2 in (sheet 2) A2. Using multiple sheets and cells, I just can't get this formula to work. Any help would be great. Thanks
Must A6 be less than each of B6, C6, E6, and F6? If so,

in A2 in Sheet2 enter:

=(SUMPRODUCT((Sheet1!B6:F6>Sheet1!A6)+0)=5)*Sheet1!A2

which is more concise than IF with a long AND.

3. try =(A6
add your sheet references and check what result you want for negative test.

The above gives value of a2 if true and
0 if false.

4. On 2002-03-13 12:00, Dave Patton wrote:

try =(A6 < MIN(B6:F6))*A2

add your sheet references and check what result you want for negative test.

The above gives value of a2 if true and
0 if false.
That's the right one, Dave. Guess i need more coffie.

Watch out for the less than sign: just disable HTML.

& glad to see you here.

[ This Message was edited by: Aladin Akyurek on 2002-03-13 12:04 ]

I wondered why the formula did not show.

Dave Patton

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•