I want my cell called total, to look at another cell called Price: in this example the vale in Price = 14
I want the cell called total to look at columns A1 and A2 and find where price falls,
in this case Price is 14 so it should see that it is equal or greater than A1, and equal or less than A2, in this example the total shown in A3 would be $11.00
I know this is simple, but I can not get it to work for me. Please help.