gebo84
Board Regular
- Joined
- Nov 6, 2014
- Messages
- 96
- Office Version
- 365
- Platform
- Windows
Hi All,
I have a price calculator I'm trying to set up, and i want the costs to update depending on the number that is input into a cell.
So in B12 the Qty will be entered and i need this to update cell B14 based on a couple of things.
if the number is between 10-19 i need it to return the value in cell N3
if the number is between 20-49 i need it to return the value in cell N4
if the number is between 50-99 i need it to return the value in cell N5
if the number is between 100-199 i need it to return the value in cell N6
if the number is between 200-299 i need it to return the value in cell N7
if the number is between 300-499 i need it to return the value in cell N8
if the number is between 500-999 i need it to return the value in cell N9
if the number is between 100-1999 i need it to return the value in cell N10
I've tried the IF formula combined with the IF(AND formula and i cant get it to work
thanks
I have a price calculator I'm trying to set up, and i want the costs to update depending on the number that is input into a cell.
So in B12 the Qty will be entered and i need this to update cell B14 based on a couple of things.
if the number is between 10-19 i need it to return the value in cell N3
if the number is between 20-49 i need it to return the value in cell N4
if the number is between 50-99 i need it to return the value in cell N5
if the number is between 100-199 i need it to return the value in cell N6
if the number is between 200-299 i need it to return the value in cell N7
if the number is between 300-499 i need it to return the value in cell N8
if the number is between 500-999 i need it to return the value in cell N9
if the number is between 100-1999 i need it to return the value in cell N10
I've tried the IF formula combined with the IF(AND formula and i cant get it to work
thanks