View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
George Gee George Gee is offline
external usenet poster
 
Posts: 109
Default 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..