G
Guest
Guest
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
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