J
Joe
i need A1/2 =B2 & C2
A1 B2 C2
$10.25 /2 5.15 5.10
A1 B2 C2
$10.25 /2 5.15 5.10
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Don Guillett
Let's see how my mindreading skills are working this morning
=ROUND(A14/2/5,2)*5
=5.15
=ROUND(A14/2/5,2)*5
=5.15
P
pinmaster
Hi
Not sure if this is what you want but try:
in B2: =CEILING(A1/2,.05)
in C2: =A1-B2
HTH
Jean-Guy
Not sure if this is what you want but try:
in B2: =CEILING(A1/2,.05)
in C2: =A1-B2
HTH
Jean-Guy
G
Gary''s Student
In A1 enter:
=(B2+C2)*2
It will display as 20.50
=(B2+C2)*2
It will display as 20.50
J
Joe
thank you
pinmaster said:Hi
Not sure if this is what you want but try:
in B2: =CEILING(A1/2,.05)
in C2: =A1-B2
HTH
Jean-Guy