| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
HELP with A1/2 =B2 & C2
i need A1/2 =B2 & C2
A1 B2 C2 $10.25 /2 5.15 5.10 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
