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

[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

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

Frank, did you go Anonymous?

Aladin