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..
|