|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
July 30th, 2009, 05:08 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
Formulas that reference a cell with numbers and text
How do you create a formula with the end results being a dollar amount when
the cell that the formula references has numbers and text? Example: 5 Boxes at 5.99=$29.99 
|
|
#2
July 30th, 2009, 06:24 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
Formulas that reference a cell with numbers and text
You've posted in a newsgroup dedicated to supporting Microsoft Access, the
relational database. Database tables don't have "cells". Do you need to post to an Excel newsgroup? Regards Jeff Boyce Microsoft Office/Access MVP "donnae" wrote in message ... How do you create a formula with the end results being a dollar amount when the cell that the formula references has numbers and text? Example: 5 Boxes at 5.99=$29.99
|
|
#3
July 30th, 2009, 07:01 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
Formulas that reference a cell with numbers and text
Use Access. Access is better at math than whereever you got your example
from! Steve "donnae" wrote in message ... How do you create a formula with the end results being a dollar amount when the cell that the formula references has numbers and text? Example: 5 Boxes at 5.99=$29.99
|
|
#4
July 30th, 2009, 08:03 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
Formulas that reference a cell with numbers and text
Excel does numbers.
Access does databases/applications. Do you have any references to cite for why you believe "Access is better at math"? Regards Jeff Boyce Microsoft Office/Access MVP "Steve" help_available_at_very_reasonable_rates@contactme .com wrote in message m... Use Access. Access is better at math than whereever you got your example from! Steve "donnae" wrote in message ... How do you create a formula with the end results being a dollar amount when the cell that the formula references has numbers and text? Example: 5 Boxes at 5.99=$29.99
|
|
#5
July 30th, 2009, 09:49 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
Formulas that reference a cell with numbers and text
5 Boxes at 5.99 does not equal $29.99. Access is better at math than
whereever the OP got his example from! "Jeff Boyce" wrote in message ... Excel does numbers. Access does databases/applications. Do you have any references to cite for why you believe "Access is better at math"? Regards Jeff Boyce Microsoft Office/Access MVP "Steve" help_available_at_very_reasonable_rates@contactme .com wrote in message m... Use Access. Access is better at math than whereever you got your example from! Steve "donnae" wrote in message ... How do you create a formula with the end results being a dollar amount when the cell that the formula references has numbers and text? Example: 5 Boxes at 5.99=$29.99
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
