On Dec 21, 2:32*am, Eqa wrote:
Can you help me to include the 2.5 times the cost price into the
formula you suggested. It works fine but I can't add the 2.5 into it.

=if(mod(2.5*A1,100)=78, 100*int(2.5*A1/100)+98,
if(mod(2.5*A1,100)<28, 100*int(2.5*A1/100)-2,
100*int(2.5*A1/100)+58))

By the way, do you realize that I extended your requirements, rounding
integers ending in anything less than 27 down to a number ending in
98? For example, 8827 becomes 8798. You need to ask yourself if that
is what you intended.