HELP with A1/2 =B2 & C2

[Guest]

i need A1/2 =B2 & C2

A1 B2 C2
$10.25 /2 5.15 5.10

 

[Don Guillett]

Let's see how my mindreading skills are working this morning

=ROUND(A14/2/5,2)*5
=5.15

 

[Guest]

Hi

Not sure if this is what you want but try:

in B2: =CEILING(A1/2,.05)
in C2: =A1-B2

HTH
Jean-Guy

 

[Guest]

In A1 enter:
=(B2+C2)*2

It will display as 20.50

 

[Guest]

thank you

Hi

Not sure if this is what you want but try:

in B2: =CEILING(A1/2,.05)
in C2: =A1-B2

HTH
Jean-Guy