Multiple "IF" in One Cell

Hi guys,
Im trying to create a spreadsheet to make work easier.

I need to have multiple "IF" in one cell but not sure how to make it work.

Basically I have a drop down list in
C2 "Straight bars","Bent or Hooked Bars", and "Looped Bars"

In E7 I'm trying to provide a value;
if C2 = Straight Bars then E7 = min(E4:E6)
if C2 = Bent or Hooked Bars then E7 = min(E4,E6)
if C2 = Looped Bars then E7 = E5

Just wondering is it possible to make this work?

Thanks in advance!

Capture.JPG

Attachment 396244

Hi,

Welcome to the Forum,

Try the following formula in E7:

=IF(C2="Straight Bars ",MIN(E4:E6),IF(C2="Bent or Hooked bars",MIN(E4,E6),IF(C2="Looped Bars",E5,"")))

Try this.
=IF(OR(C2="Bent or Hooked Bars",C2="Straight bars"),MIN(E4:E6),$E$4)

Many Thanks cbatrody!
The formula worked great!
Much appreciated!

Originally Posted by adhawan06

The formula provided in Post 2 is good but I wonder why you should two mutiple criteria for the same result?? If C2 = "Straight bars" Or "Bent or Hooked Bars" then your result should return to Minimum value from E4 to E6. Post#3 and Post#5 functions will also fit in your requirement if you wish to use them.


Cheers!!!
Anil Dhawan

Please look at the description provided by the OP carefully, there is a difference between MIN(E4:E6) & MIN(E4,E6), E5 is omitted in the second instance!!!

Originally Posted by TCH86

Many Thanks cbatrody!
The formula worked great!
Much appreciated!

You are welcome TCH86.

If that takes care of your question, please mark this thread as Solved by selecting Thread Tools --> Mark thread as solved.

Originally Posted by cbatrody

Please look at the description provided by the OP carefully, there is a difference between MIN(E4:E6) & MIN(E4,E6), E5 is omitted in the second instance!!!

Oooopsss My bad..I didn't look at that carefully...


@OP - you can Ignore my post for this

Thanks @Cbatrody for making me correct..


Cheers!!!
Anil Dhawan