PDA

View Full Version : Solved: MIN formula



lee2boy
02-26-2010, 05:29 PM
Chaps, can any body help with a formula, I have tried all sorts,
I'm trying to record in a cell the smallest cash figure for a number of cells in a row
i.e
a2, f2, g2 i2, k2 ,m2 etc,
but the cells may contain a zero or be blank
thanks if any body can help
Regards,
Lee

krishhi
02-26-2010, 09:28 PM
can u go more specific

lee2boy
02-27-2010, 02:48 AM
I'll try,
If cell a2 has £1.50 in it and if cell f2 is not filled in and if g2 has £163.00 and if i2 has 90p and if k2 is 0 and m2 has £6.00 i wish to record in another cell the lowest value which is i2 with 90p, but not the 0 in k2 or get a false due to f2 not being filled in .
Hope that makes sence
Thanks
Lee

Bob Phillips
02-27-2010, 02:52 AM
Try this ARRAY formula

=MIN(IF(N(OFFSET(A2,0,{0,5,6,8,10,12},1,1))<>0,N(OFFSET(A2,0,{0,5,6,8,10,12},1,1))))

lucas
02-27-2010, 10:01 AM
Very nice Bob. I'm always in awe of your solutions.

lee2boy
02-27-2010, 01:40 PM
Top Man
Thanks for that
Lee

lucas
02-27-2010, 01:59 PM
Lee, be sure to mark your thread solved using the thread tools at the top of the page.

That prevents members from reading the entire thread just to find it's been solved.

lee2boy
02-27-2010, 02:03 PM
All done steve