1

I need to have a formula that will choose the Least value out of 3 cells

view story
linux-howto

http://superuser.com – I need to have a formula that will choose the least value out of 3 cells. Cells are as follows with random numbers I29=5 I30=10 I31=15 Currently I’m using =rounddown(if(I29<I30,if(I29<I30,I29,I31),I30)) And the cells are as follows I29=217 I30=304 I31=51 This formula works with the first set with I29 coming out with the lowest number of 5, but with the current set comes out with I29 sill coming out with the lowest number at 217, which is bigger than I31 at 51 This formula is also set to take whatever number is chosen and round it down because I need whole numbers after (HowTos)