Hello,

I am an amateur for sure at excel but always on the hunt for more knowledge. I am trying to figure out if something here is even possible. I have an order form and a price list. I get different pricing based on the quantity I purchase. I would like to have the price auto populate based on the quantity entered. The price will be on another sheet.

I couldn't find a lot of info but I also may not know where to look.

example:


if (b2<62) then price is ($sheet2.b2)
if (b2<124) then price is ($sheet2.c2)
if (b2<372) then price is ($sheet2.d2)

Is this even possible to put into a formula?

Thanks everyone for your help