Multiple IF formulas
You are welcome.
I've spent more time then most analyzing bid proposals.
I don't know whether Excel now makes it easier or not.
I do have a overwrought and never used Purchase
Analysis Program (workbook) that I wrote years ago.
It includes the cost of carrying inventory in making the buy decision.
Maybe somebody reading this would like to fight with it. <g
--
Jim Cone
Portland, Oregon USA
"Dmiller"
wrote in message
this works... :) thank you very much.
--
Debmil
"Jim Cone" wrote:
Further:
And maybe this is what you wanted ?...
=IF(MIN(S2,W2,AA2)<=J2,IF(AND(S2<W2,S2<AA2),P2,IF( AND(W2<S2,W2<AA2),T2,IF(AND(AA2<S2,AA2<W2),X2,"Tie "))),"None")
--
Jim Cone
Portland, Oregon USA
|