HELP with A1/2 =B2 & C2
 

i need A1/2 =B2 & C2

A1 B2 C2
$10.25 /2 5.15 5.10

HELP with A1/2 =B2 & C2
 

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

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


--
Don Guillett
SalesAid Software

"Joe" wrote in message
...
i need A1/2 =B2 & C2

A1 B2 C2
$10.25 /2 5.15 5.10

HELP with A1/2 =B2 & C2
 

Hi

Not sure if this is what you want but try:

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

HTH
Jean-Guy

"Joe" wrote:

i need A1/2 =B2 & C2

A1 B2 C2
$10.25 /2 5.15 5.10

HELP with A1/2 =B2 & C2
 

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

It will display as 20.50

--
Gary''s Student


"Joe" wrote:

i need A1/2 =B2 & C2

A1 B2 C2
$10.25 /2 5.15 5.10

HELP with A1/2 =B2 & C2
 

thank you


"pinmaster" wrote:

Hi

Not sure if this is what you want but try:

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

HTH
Jean-Guy

"Joe" wrote:

i need A1/2 =B2 & C2

A1 B2 C2
$10.25 /2 5.15 5.10