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