Multiple IF statements help

[RonnieLaarnie]

I am trying to create/edit a spreadsheet for my new job. I am trying to put multiple "IF" statements in one cell, but I can't figure it out. In B10 "Mix Requested, I made it a drop down with the Concrete Cost Per Yard; 3000, 3500, etc. How can I use multiple IF statements to blow the cost in B12 "Concrete"? =IF(B10=3000,146),IF(B10=3500,151),IF(B10=4000,153...etc..... See what I want to do? Please help. I am no expert with Excel. Just trying to calculate price based on mix and quantity. All help is appreciated. Thanks, Ronnie

 

[James006]

Hi,

You seem to already have a reference table ... so, instead of nested Ifs ... you could use a VLookup() function ...

 

[Fluff]

Hi & welcome to MrExcel.
How about

=VLOOKUP(B10,H6:I10,2,0)