MrExcel Publishing
Your One Stop for Excel Tips & Solutions

formula assistance if/than ??

Posted by Celeste on February 15, 2001 10:47 AM

i have four columns (we'll call them B,C,D,E). i need to come up with a formula (not code) in column F that says:

equal the cheapest price out of columns B-E on this row

then i need to fill them down. i don't know if i'm explaining this good enough, here's another example

column B1 has $1
column C1 has $2
column D1 has $3
column E1 has $4

i want F1 to equal the cheapest price, which would be equal to B1


Posted by Aladin Akyurek on February 15, 2001 10:58 AM

Is it not just

F1 =MIN(B1:D1)

then select B1 to D1 and copying down as far as needed?


Posted by John S. on February 15, 2001 11:00 AM

try: =min(B1:E1)