If / Then Function or Formula

[frankg]

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

 

[Aladin Akyurek]

On 2002-03-13 10:45, frankg 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

I believe I replied to this in a more recent thread.

Frank, did you go Anonymous?

Aladin