creating a calculator in excel

peteb2001

New Member
I'm trying to create a calculator type formula - where if the qty (say 25) entered in a cell is higher than 10 but lower than 49 then multiply by cell A1.

this would continu until i had cover the different qty breaks (numbers entered) against the cost per item

can any one help

regards

P

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).

tusharm

MrExcel MVP
Put the thresholds and the multiplication amounts/references in a 2 column table. Then, use VLOOKUP to find the appropriate multiplier. For more see VLOOKUP in Excel help.

peteb2001

New Member
Thanks Tusharm

for the response but i'm not a great exceler so i dont really understand Vlookup etc

I think I will create a simpler chart

regard

pete

ravishankar

Well-known Member
HI
if cell B1 has your quantity (say 25)
C1 = =if(and(B1>10,B1<49),B1*A1,"over the limits")
drag the formula down. is this what you are looking for?
Ravi

peteb2001

New Member
Hi Ravi

thats a lot simpler and seem to be doing the job

Thanks!!

p

Replies
1
Views
211
Replies
4
Views
163
Replies
1
Views
252
Replies
2
Views
333
Replies
4
Views
387

1,191,036
Messages
5,984,268
Members
439,881
Latest member
Amitoj95

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back