I have three suppliers that have submitted quotes. (MSC) (Fastenal) (Grainger). In the past, I only had to compare 2 columns with a simple formula. Now the third column of data is causing syntax problems when I try to write a formula. I need to produce a formula which shows the lowest cost between 3 suppliers. Any Help?
Try the MIN formula for example:
=MIN(A1:A3)
It will return the smaller value within the rows 1 2 and 3
If you are pleased with a member's answer then use the Star icon to rate it.Remember to mark your questions Solved and rate the answer(s)
Anyway to have the lowest cost reference the column heading? i.e. Grainger. The "min" formulation has me in the right direction.
something like this:
=MIN(J2:L2)
here, data in row 2 across three columns J, K, L are included in determination of the 'minimum' value.
- i.s.z -
CSE, aka Array aka { }, formulae are confirmed with CONTROL+SHIFT+ENTER.
Replace commas ( , ) with semicolons ( ; ) in formulae, if your locale setting demands.
All good ideas are courtesy resources from this forum as well as others around the web.
- e.o.m -
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks