|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 14th, 2009, 03:54 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
Greater/Less Than or Equal To
I have a spreadsheet for work where I need to calculate the price of our
services. If you buy 0-30 items, they are $13 a piece, 31-99 is $12 each, and 100+ is $11. I need to put a formula into a column that can calculate this automatically. The cell with the final quantity is T10, so the first part of the equation should look something like this: =IF(T1031, 13) That works for all numbers less than 31, but I need the other two parts added in there. Please help. 
|
|
#2
May 14th, 2009, 04:01 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Greater/Less Than or Equal To
=IF(T1031,13,IF(T10100,12,11)) Hoov wrote: I have a spreadsheet for work where I need to calculate the price of our services. If you buy 0-30 items, they are $13 a piece, 31-99 is $12 each, and 100+ is $11. I need to put a formula into a column that can calculate this automatically. The cell with the final quantity is T10, so the first part of the equation should look something like this: =IF(T1031, 13) That works for all numbers less than 31, but I need the other two parts added in there. Please help.
|
|
#3
May 14th, 2009, 04:06 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Greater/Less Than or Equal To
One way.......
=IF(T1031,13,IF(T10100,12,11)) Vaya con Dios, Chuck, CABGx3 "Hoov" wrote: I have a spreadsheet for work where I need to calculate the price of our services. If you buy 0-30 items, they are $13 a piece, 31-99 is $12 each, and 100+ is $11. I need to put a formula into a column that can calculate this automatically. The cell with the final quantity is T10, so the first part of the equation should look something like this: =IF(T1031, 13) That works for all numbers less than 31, but I need the other two parts added in there. Please help.
|
|
#4
May 14th, 2009, 04:10 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Greater/Less Than or Equal To
Hi
=IF(T10="","",IF(T1099,11,IF(T1030,12,13))) or, marginally shorter, =IF(T10="","",11+(T10100)*2+(T1031)*1) -- Regards Roger Govier "Hoov" wrote in message ... I have a spreadsheet for work where I need to calculate the price of our services. If you buy 0-30 items, they are $13 a piece, 31-99 is $12 each, and 100+ is $11. I need to put a formula into a column that can calculate this automatically. The cell with the final quantity is T10, so the first part of the equation should look something like this: =IF(T1031, 13) That works for all numbers less than 31, but I need the other two parts added in there. Please help.
|
|
#5
May 14th, 2009, 04:41 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Greater/Less Than or Equal To
=IF(T10=30, 13, IF(T10=99, 12, 11))
-- David Biddulph "Hoov" wrote in message ... I have a spreadsheet for work where I need to calculate the price of our services. If you buy 0-30 items, they are $13 a piece, 31-99 is $12 each, and 100+ is $11. I need to put a formula into a column that can calculate this automatically. The cell with the final quantity is T10, so the first part of the equation should look something like this: =IF(T1031, 13) That works for all numbers less than 31, but I need the other two parts added in there. Please help.
|
|
#6
May 14th, 2009, 05:54 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Greater/Less Than or Equal To
Give this formula a try...
=11+(A1100)+(A131) -- Rick (MVP - Excel) "Hoov" wrote in message ... I have a spreadsheet for work where I need to calculate the price of our services. If you buy 0-30 items, they are $13 a piece, 31-99 is $12 each, and 100+ is $11. I need to put a formula into a column that can calculate this automatically. The cell with the final quantity is T10, so the first part of the equation should look something like this: =IF(T1031, 13) That works for all numbers less than 31, but I need the other two parts added in there. Please help.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
