RonnieLaarnie
New Member
- Joined
- Mar 11, 2023
- Messages
- 1
- Office Version
- 2007
- Platform
- Windows
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