Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
IF funtion question
Hi all,
Kindly assist on the following: eg: 10.00 per 1st 5 items, 5.00 per every additional 5 items Thus, if the total is 20 items, then the answer would be 20.00 Pls adv on generating the formula for the above. Thanks in advance. wm.. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
IF funtion question
Is your maths right?
=A1-5+10 George Gee "wm" wrote in message ... Hi all, Kindly assist on the following: eg: 10.00 per 1st 5 items, 5.00 per every additional 5 items Thus, if the total is 20 items, then the answer would be 20.00 Pls adv on generating the formula for the above. Thanks in advance. wm.. |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
IF funtion question
To simplify:
=A1+5 George Gee "George Gee" wrote in message ... Is your maths right? =A1-5+10 George Gee "wm" wrote in message ... Hi all, Kindly assist on the following: eg: 10.00 per 1st 5 items, 5.00 per every additional 5 items Thus, if the total is 20 items, then the answer would be 20.00 Pls adv on generating the formula for the above. Thanks in advance. wm.. |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
IF funtion question
i guss ur eq is wrong. according to ur logic if the total is 20 items, then
the answer would be 25.00 however see the below mentioned foumula =IF(A1=5,10+INT((A1-5)/5)*5,10) or =IF(A1=5,10+((A1-5)/5)*5,10) u can try both formula if u need further information, pls let me know pls do rating "wm" wrote: Hi all, Kindly assist on the following: eg: 10.00 per 1st 5 items, 5.00 per every additional 5 items Thus, if the total is 20 items, then the answer would be 20.00 Pls adv on generating the formula for the above. Thanks in advance. wm.. |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
IF funtion question
Sorry, if someone could explain the original posters logic.
To me the answer to the original question is 25. George Gee "Muhammed Rafeek M" wrote in message ... i guss ur eq is wrong. according to ur logic if the total is 20 items, then the answer would be 25.00 however see the below mentioned foumula =IF(A1=5,10+INT((A1-5)/5)*5,10) or =IF(A1=5,10+((A1-5)/5)*5,10) u can try both formula if u need further information, pls let me know pls do rating "wm" wrote: Hi all, Kindly assist on the following: eg: 10.00 per 1st 5 items, 5.00 per every additional 5 items Thus, if the total is 20 items, then the answer would be 20.00 Pls adv on generating the formula for the above. Thanks in advance. wm.. |
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
IF funtion question
Gee George, your right (vbg). I would suggest the OP post again with exactly
what he wants! 10+5+5+5=25, not 20. If the anser is to be 20, then some logic is missing, so no one will really be in a position to help him! To try and get to 20, is an excercise in futility, as it will not help the person. -- Hth Kassie Kasselman "George Gee" wrote: Sorry, if someone could explain the original posters logic. To me the answer to the original question is 25. George Gee "Muhammed Rafeek M" wrote in message ... i guss ur eq is wrong. according to ur logic if the total is 20 items, then the answer would be 25.00 however see the below mentioned foumula =IF(A1=5,10+INT((A1-5)/5)*5,10) or =IF(A1=5,10+((A1-5)/5)*5,10) u can try both formula if u need further information, pls let me know pls do rating "wm" wrote: Hi all, Kindly assist on the following: eg: 10.00 per 1st 5 items, 5.00 per every additional 5 items Thus, if the total is 20 items, then the answer would be 20.00 Pls adv on generating the formula for the above. Thanks in advance. wm.. |
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
IF funtion question
Kassie
As the OP has not replied to any posts in this thread, one must assume that he is otherwise occupied, or that the "20" was a typo! Also, the formula(s) provided by "Muhammed Rafeek M", will probably meet his requirements. George Gee "kassie" (Change all to lowercase) wrote in message ... Gee George, your right (vbg). I would suggest the OP post again with exactly what he wants! 10+5+5+5=25, not 20. If the anser is to be 20, then some logic is missing, so no one will really be in a position to help him! To try and get to 20, is an excercise in futility, as it will not help the person. -- Hth Kassie Kasselman "George Gee" wrote: Sorry, if someone could explain the original posters logic. To me the answer to the original question is 25. George Gee "Muhammed Rafeek M" wrote in message ... i guss ur eq is wrong. according to ur logic if the total is 20 items, then the answer would be 25.00 however see the below mentioned foumula =IF(A1=5,10+INT((A1-5)/5)*5,10) or =IF(A1=5,10+((A1-5)/5)*5,10) u can try both formula if u need further information, pls let me know pls do rating "wm" wrote: Hi all, Kindly assist on the following: eg: 10.00 per 1st 5 items, 5.00 per every additional 5 items Thus, if the total is 20 items, then the answer would be 20.00 Pls adv on generating the formula for the above. Thanks in advance. wm.. |
#8
Posted to microsoft.public.excel.newusers
|
|||
|
|||
IF funtion question
Maybe.........
=TEXT(COUNT(A1:A20),"0.00") Vaya con Dios, Chuck, CABGx3 "wm" wrote in message ... Hi all, Kindly assist on the following: eg: 10.00 per 1st 5 items, 5.00 per every additional 5 items Thus, if the total is 20 items, then the answer would be 20.00 Pls adv on generating the formula for the above. Thanks in advance. wm.. |
#9
Posted to microsoft.public.excel.newusers
|
|||
|
|||
IF funtion question
no of items on A1.
=IF(A110,15+(A1-10)/2,IF(A1=5,10+(A1-5),IF(A1<5,A1*2,"X"))) 20 items = 20.00 15 items=17.50 10 items = 15.00 5 items = 10.00 maybe this is formulated for reduced selling price as qty of item increase. "wm" wrote: Hi all, Kindly assist on the following: eg: 10.00 per 1st 5 items, 5.00 per every additional 5 items Thus, if the total is 20 items, then the answer would be 20.00 Pls adv on generating the formula for the above. Thanks in advance. wm.. |
#10
Posted to microsoft.public.excel.newusers
|
|||
|
|||
IF funtion question
None of the answers so far appear to me to be correct. I believe the OP
meant that the cost increments like this: 1-5 10.00 6-10 15.00 11-15 20.00 16-20 25.00 21-25 30.00 If so, and taking into account that zero items should probably not cost $10,00, the formula might look like this: =IF(A10,5+INT((A1+4)/5)*5,0) dribler2 wrote: no of items on A1. =IF(A110,15+(A1-10)/2,IF(A1=5,10+(A1-5),IF(A1<5,A1*2,"X"))) 20 items = 20.00 15 items=17.50 10 items = 15.00 5 items = 10.00 maybe this is formulated for reduced selling price as qty of item increase. "wm" wrote: Hi all, Kindly assist on the following: eg: 10.00 per 1st 5 items, 5.00 per every additional 5 items Thus, if the total is 20 items, then the answer would be 20.00 Pls adv on generating the formula for the above. Thanks in advance. wm.. -- Gary L. Smith Columbus, Ohio |
#11
Posted to microsoft.public.excel.newusers
|
|||
|
|||
IF funtion question
Thanks all for the replies. Actually, there was typing error. the correct
anwer for the below (1st eg) is 25. On top of the below requirement, there is another criteria as following: If the charge for 1st set is 10.00, 5.00 per very additional set. And 1 set can consist of 5 items. Eg: if there are 17 items, then there should be 4 sets , so charges are 25.00 *eventhough the 4th set consists of 3 items only, but it will be charged as 5.00 for the particular set. I have tried out this, A1= no. of items =IF(A1/51,ROUNDUP(A1/5-1,0)*5+10,10) Wm....... "George Gee" wrote: Kassie As the OP has not replied to any posts in this thread, one must assume that he is otherwise occupied, or that the "20" was a typo! Also, the formula(s) provided by "Muhammed Rafeek M", will probably meet his requirements. George Gee "kassie" (Change all to lowercase) wrote in message ... Gee George, your right (vbg). I would suggest the OP post again with exactly what he wants! 10+5+5+5=25, not 20. If the anser is to be 20, then some logic is missing, so no one will really be in a position to help him! To try and get to 20, is an excercise in futility, as it will not help the person. -- Hth Kassie Kasselman "George Gee" wrote: Sorry, if someone could explain the original posters logic. To me the answer to the original question is 25. George Gee "Muhammed Rafeek M" wrote in message ... i guss ur eq is wrong. according to ur logic if the total is 20 items, then the answer would be 25.00 however see the below mentioned foumula =IF(A1=5,10+INT((A1-5)/5)*5,10) or =IF(A1=5,10+((A1-5)/5)*5,10) u can try both formula if u need further information, pls let me know pls do rating "wm" wrote: Hi all, Kindly assist on the following: eg: 10.00 per 1st 5 items, 5.00 per every additional 5 items Thus, if the total is 20 items, then the answer would be 20.00 Pls adv on generating the formula for the above. Thanks in advance. wm.. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Possibly a loaded question, but I think | Excel Discussion (Misc queries) | |||
How do I find and replace a question mark in Excel? | Excel Discussion (Misc queries) | |||
Newbie With A Question | Excel Worksheet Functions | |||
Anybody Help with previous question | Excel Discussion (Misc queries) | |||
Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions |